Running data script fails

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Running data script fails

Postby keymoo » Fri Oct 19, 2007 9:27 am

Hi,

I have scripted out a database using SQL Packager version 5.4.0.89 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?

Thanks,
keymoo
keymoo
 
Posts: 27
Joined: Fri Oct 19, 2007 9:22 am

Postby keymoo » Fri Oct 19, 2007 12:26 pm

I managed to eliminate this problem by reducing the amount of data I script out. I have saved the data as a set of INSERT statements directly from SQL Packager.

If I run this file into my SQL 2005 SP2 server using sqlcmd.exe I get this error:
Code: Select all
Msg 701, Level 17, State 123, Server SQLSERVER1, Line 25719
There is insufficient system memory to run this query.

Any ideas how to fix that one?

Thanks
keymoo
 
Posts: 27
Joined: Fri Oct 19, 2007 9:22 am

Postby Brian Donahue » Sun Nov 04, 2007 6:49 pm

Hi,

This looks to be a complex problem with a multitude of causes. Microsoft cover this on their Technet site, but there doesn't seem to be a clear solution except to increase the server memory or clear out some of SQL Server 2005's caches ie DBCC FREEPROCCACHE.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests