Feb 24th, 2012, 09:10 AM
issue trying to deploy a DB Project from VS2010
In our solution we have a DB project. Deployment from this (right mouse click on project and select deploy). Has been working no problem. We also have script file used to run SQlCmd commands typically to load static data into some reference tables. (:r .\MySqlInsert.sql)
I have now created 2 files covering some 49000 insert statements into a single table.Both files parse fine after I placed 'Go' statements throught both docs.
However, when I try to deploy I receive 'outofmemoryexception' errors. Through tools/options/transact-SQL/intellisense I have set maximum script size to unlimited. In an ideal world this amount of inserts would be held externally and run in to SQL as a Standard script, however the client want these deployed with the project. Anybody any ideas.
Click Here to Expand Forum to Full Width