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).