Feature suggestion -- batch size
scottnelson
Posts: 29
One feature that would greatly help me out is the ability to specify a batch size. I.e., after every so many SQL statements, insert a "GO".
I frequently use SQL Data Compare to generate scripts that I then zip (because they are huge), copy to another box, unzip, and then execute there from osql.exe via a Terminal Server command shell. (This allows me to shut down my laptop where Red Gate is installed and still have the script keep going.)
Because osql appears to buffer the script in memory until it hits a "GO," it seems to use excessive memory. Having the ability to specify the batch size would eliminate this.
I know this wouldn't work if using transactions, but that's OK for most purposes.
thanks.
I frequently use SQL Data Compare to generate scripts that I then zip (because they are huge), copy to another box, unzip, and then execute there from osql.exe via a Terminal Server command shell. (This allows me to shut down my laptop where Red Gate is installed and still have the script keep going.)
Because osql appears to buffer the script in memory until it hits a "GO," it seems to use excessive memory. Having the ability to specify the batch size would eliminate this.
I know this wouldn't work if using transactions, but that's OK for most purposes.
thanks.
Comments
For your reference the feature tracking code is: SDC-771