Help ! Urgent ! Error when package a SQL file.

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Help ! Urgent ! Error when package a SQL file.

Postby nnodari » Mon Oct 18, 2010 8:23 pm

I´m 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
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby peter.peart » Wed Oct 20, 2010 9:24 am

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/vi ... 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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby nnodari » Wed Oct 20, 2010 11:31 am

I solved downgrading from 6.3.1.92 to 6.3.1.7.

Also, I´ll 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/C ... 000376.htm) - and the line isn´t 421 in new versions. How to fix ?

Regards
Att
nnodari
 
Posts: 19
Joined: Mon Mar 30, 2009 9:04 pm

Postby peter.peart » Thu Oct 28, 2010 6:26 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 1 guest