sql-server


Unable to add database reference for dacpac in Visual Studio 2012 - OutOfMemoryException


I have a dacpac that is 12 MB and which took 45 minutes to generate within VisualStudio 2012. It is for a production Microsoft Dynamics GP (formerly Great Plains) customer database. I was amazed that I was able to get the dacpac created in the first place, but it appears to be useless in any of the development tools (Visual Studio 2012 or SSMS 2012). Now I see that even Windows Azure has a 5 MB limit (DacPac is too big error - but my file is only 406kb).
I am receiving OutOfMemoryException even in the SSMS 2012 IDE.
For what it is worth, the .model temp file grew to 1.5 GB while Visual Studio 2012 created the dacpac.
Any ideas how I might be able to add the database reference in Visual Studio or import the dacpac into SQL Server (perhaps in stages)? Is there just a hard limit to what the tools can use?
I've just been trying to import a database from a bacpac file and was getting a similar OutOfMemoryException. However after I closed and reopened management studio it worked OK.

Related Links

SQL Server function with parameters
Bulk Load Data Conversion Error - Can't Find Answer
when i exec select on linux with odbc, hang on '__select_nocancel'
The system cannot find the file specified on Production server
An Error when trying to connect to SQL Server
Informatica powercenter
Temporary table not created from dynamic query execution
How to process the data in the table, which is frequently inserted
Combine two columns and input the result in a different columns using SQL server
SQL Query to accept time difference
How to change my T-SQL query to overwrite a csv file rather than append data to it?
How to join multiple columns with only one foreign key using linq
Deleting millions on records while using log shipping - SQL Server
Restricting decimal places [duplicate]
Powershell T-SQL Update Statement Error in Function
How to close if case in SQL

Categories

HOME
cil
app-inventor
udp
admin-on-rest
meshlab
vhdl
jar
nlp
google-contacts
decorator
cocos2d-x-3.0
extract
tomcat7
schemacrawler
apiconnect
docker-windows
getorgchart
jboss-eap-7
iso
jboss7.x
hashicorp-vault
uiscrollview
local
zoho
nmake
google-ima
ghost-inspector
facebook4j
samsung-mobile
nesc
configure
bitcoin-testnet
protobuf-net
m2e
geopy
remote-server
hashcat
liquid-xml
mongoexport
twiki
code-composer
median
dojox.grid.datagrid
openweathermap
web-deployment-project
sapui
spring-data-hadoop
udev
crash-reports
python-hypothesis
jcreator
qos
createobject
inject
push-diffusion
easing
uiprogressview
spatial-query
faraday
gradle-release-plugin
application-loader
futuretask
bridge
lines-of-code
sysfs
multipleselection
cocoascript
omnifocus
odftoolkit
errorprovider
vcl
getimagedata
alpha-transparency
sgml
joox
crystal-reports-10
svcutil.exe
lov
wic
nsmatrix
cgimageref
dynamics-ax-2009
gdataxml
returnurl
blockingqueue
v4l
fileutils
easygui
post-redirect-get
clause
chatroom
file-encodings
delegatecommand
linfu
multibyte-functions
asp.net-mvc-controller
swfloader
revision
project-lifecycle
data-execution-prevention

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App