Red Gate forums :: View topic - Help ! Urgent ! Error when package a SQL file.
Return to www.red-gate.com RSS Feed Available

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

Help ! Urgent ! Error when package a SQL file.

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Mon Oct 18, 2010 8:23 pm    Post subject: Help ! Urgent ! Error when package a SQL file. Reply with quote

Im trying to package a file (exactly same schema script generated by own sql packager) but getting error: Incorrect syntax near the keyword 'PRINT'.

It seems that line breaks was changed...

The same script runs perfectly in management studio.
_________________
Att
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Wed Oct 20, 2010 9:24 am    Post subject: Reply with quote

Hi there and thanks for your post. Can you confirm which exact version of SQL Packager you are running? If you are not using the latest cumulative patch, can you please try that? It is available from the below link:

http://www.red-gate.com/messageboard/viewtopic.php?t=9883

Many thanks!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
nnodari



Joined: 30 Mar 2009
Posts: 19

PostPosted: Wed Oct 20, 2010 11:31 am    Post subject: Reply with quote

I solved downgrading from 6.3.1.92 to 6.3.1.7.

Also, Ill take this opportunity to mention:

1) Tip: I tried to change to USE TRANSACTION and I received a similar error
(http://www.legalsistemas.com.br/packager.png) - line breaks was changed in package process - many tested encodings (unicode, ansi, utfs)
2) Sugestion: To create/drop/alter an object, ask if there (IF EXISTS)
3) Protest: Each update request templates reconfiguration (http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Packager&c=knowledgebase%5CSQL_Packager%5CKB200903000376.htm) - and the line isnt 421 in new versions. How to fix ?

Regards
_________________
Att
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Oct 28, 2010 6:26 pm    Post subject: Reply with quote

Thanks for your post. Please allow me to address your issues as you have listed them:

1) In order for us to troubleshoot that further, we would really need to replicate it with your DB. Please feel free to send a backup to support(at)red-gate.com quoting reference F00040380 and we will take a look.
2) This is already listed as a feature request. The functionality is scheduled I believe for SQL Compare 9 due out later this year / early next year. Once that is available, I am sure the functionality will then make its way into Packager.
3) Can you confirm if you get the same behaviour if you use the /makeupgrade switch?

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
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