SQL Packager falls on its nose....

mscheuner

Guys,

I created a SQL Packager .NET app from my database I'm working on. I saved the scripts for the objects and the data and checked them in Query Analyzer - everything seems fine.

But when I go about to run the EXE, it falls flat on its nose:

"Line 4: Incorrect syntax near '('.

Any idea what that could be??

Thanks!
Marc

Daniel Handley

Hi Marc

Can you try to run the scripts in QA and see if there are any problems?

Regards
Dan

mscheuner

>>Can you try to run the scripts in QA and see if there are any problems?

They work just fine in QA, that's the puzzling thing....

Marc

Daniel Handley

Hi Marc

That is strange. All the package does ir run the scripts via the .Net ado connection rather than using the old sql dmo connection.

Is the package an upgrade or full installation? If it is full can you send it to us to try, if it is an upgrade can you send a backup and the pack?
support@red-gate.com

Regards
Dan

mscheuner

Interestingly enough, the new SQL Packager v5 beta works flawlessly on this same project - no hiccup or anything.

Daniel Handley

Hi Marc

Do you have a current support contract so you can recieve a free upgrade once v 5 is released?

Dan