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.
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
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