Red Gate forums :: View topic - Running data script fails
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Running data script fails

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
keymoo



Joined: 19 Oct 2007
Posts: 27

PostPosted: Fri Oct 19, 2007 9:27 am    Post subject: Running data script fails Reply with quote

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:

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
Back to top
View user's profile Send private message
keymoo



Joined: 19 Oct 2007
Posts: 27

PostPosted: Fri Oct 19, 2007 12:26 pm    Post subject: Reply with quote

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:
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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Sun Nov 04, 2007 6:49 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group