Generate Partial compare script files

chuckredgate

I can compare the 2 databases and generate a large deployment script. However, when the script is run on the server, it runs out of memory. Is it possible to generate a deployment script and limit the number of lines generated? It would be useful to be able to break up the script into smaller files.

Allen LeVan

Hello Chuck,

The easiest way to do this is on the result page select a smaller number of changes to deploy, do a re-compare after deploy and pick the rest or the next third or whatever percentage of changes works for your environment. This basically creates several partial deployments and you can control what each one contains.

Let me know if you need anything else, thanks.

Mark J

I think the 'Maximum batch size' option might do what you want: http://documentation.red-gate.com/displ ... on+options