SQL Packager 5.3 chokes on database compare

[mscheuner]

Folks,

I have two copies of my database, a current PROD version and the new version to be deployed. I tried to use SQL Packager 5.3 to create the upgrade script, but it keeps crashing on me.

I can pick the current and previous version of the database (SQL Server 2005 SP2), and SQL Packager compares the two just fine. I then pick the stuff I want scripted out, and SQL Packager starts creating the scripts. At about the fifth table or so, it briefly pauses, and then an error message box occurs

SQL Packager 5 has enconutered a problem and needs to close. We are sorry for the inconvenience.

I then get a prompt to start debugging is VStudio or CLR Debugger, and there's a tad more information there:

"An unhandled exception of type System.ArgumentException occured in RedGate.SQLDataCompare.Engine.dll.
An entry with the same key already exists"

Unfotunately, nothing gets logged (log file, event log).

What's up?

Greetings,
Marc

[Brian Donahue]

Hi,

Thanks for your post. Most commonly, this error will happen because you are packaging a case-sensitive database and you have not set the 'treat items as case-sensitive' option in Packager's schema options. The error alludes to two objects with the same name going into the schema collections. Treating items as case-sensitive should fix the problem in this case.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[mscheuner]

Brian,

Thanks for your response - I tried setting that option, but that doesn't help - I still get the same error at the same place in the process.

Any further ideas?

[Brian Donahue]

The root of the problem remains the same -- there are two objects with the same name in the database, or at least the engine thinks so.

What is the last status message diaplayed by Packager? At least this would give a clue which type of object is causing the problem.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[mscheuner]

Hi Brian,

Is there any way I can turn on additional logging or something to figure out WHICH object is there twice, supposedly?

Also, if you're using Hashtable or something similar, I'd suggest checking whether something already exists, and if it does, throw a custom exception that contains the info of WHAT is being added a second time.

Cheers!
Marc

[Brian Donahue]

Hi Marc,

Sorry, no. None of the programs in the bundle create any usable logs. This is incredibly frustrating for the both of us.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521