I've setup a TeamCity projects that:
1. executes SQL Data Compare which generates a script file;
2. packages that script file into a NuGetPackage.
This is accompanied by a Deployment Manager project that:
1. pulls the NuGet package from the NuGet server.
2. runs a PowerShell script (located in PostDeploy.ps1) which tells sqlcmd.exe to execute the sql script generated by Data Compare.
When the amount of data in the script file is "moderate" (I haven't figured it exactly what I mean by that just yet!), everything works fine.
However, when the script file grows larger, I get the following error from sqlcmd.exe:
There is insufficient system memory in resource pool 'internal' to run this query
From http://www.red-gate.com/messageboard/vi ... hp?t=15997 I gather that you can let SQL Data Compare break the script into transactions, but - like I point out in that thread - I haven't figured out if that option can be set from the commandline.
My question regarding Deployment Manager is:
Are there better ways of accomplishing what I'm trying to do? (I could very well be heading in the wrong direction here!)