SQL-Script - automatically add GO every xx lines

TSchwab

Hi,

I have a very large table to compare between databases. Sometimes there are 800,000 rows to insert in the new database.

When I script the 800,000 rows they are in one batch.
Is there any way to add a GO every 100 or 200 lines??? :roll:
So the execution of the script would be much faster.

Please help.

chris.buckingham

The best way is to parse the SQL script with a utility to inject a GO after so many lines. You could easily use a VB or Perl script to do this.