I have scripted out a database using SQL Packager version 22.214.171.124 against SQL Server 2005 SP2.
I saved the schema and data has two separate SQL Scripts. The schema script runs fine, however the data script gives me this error when I run it:
- Code: Select all
Msg 102, Level 15, State 1, Server SQLSERVER1, Line 45514
Incorrect syntax near '2'.
My data file is 350MB so I suspect it has something to do with the size of the file. Is there any way to put GO statements in every n number of rows? Do you think inserting GO statements will solve the problem?