-
Feb 24th, 2012, 10:10 AM
#1
Thread Starter
Fanatic Member
issue trying to deploy a DB Project from VS2010
Hi All,
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|