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 support center
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: 6348
Location: Red Gate Software
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
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