Ver 5 - Ignore Collations Option, incorrect Row Order

Forum for users of SQL Packager database archive utility

Ver 5 - Ignore Collations Option, incorrect Row Order

Postby StevenE » Thu Mar 19, 2009 10:23 am

We are using SQL Packager 5 to include some lookup data for our application. The app relies on some ID fields (identity fields) being present in the database and matching specific records, therefore the order in which the data is put in is important.

We had problems running the exe generated by SQL Packager on some systems where it complained about a mismatch between the collations, so we selected the Ignore Collations option. This made the exe work, however it no longer inserts the data in the same order source database tables (i.e the IDs to not match)

How can we get around this problem.

Many Thanks
Steven Elliott
Software Developer
Shire Systems LTD
Posts: 9
Joined: Mon Jun 04, 2007 9:36 am

Postby Brian Donahue » Sun Mar 22, 2009 1:00 pm

Hi Steven,

SQL Packager upgrade packages are static -- producing a data update between two databases will result in identity values that exactly match the ones in the source database. So if you run the resulting upgrade against a third database, you will get the source database's hard-coded IDs instead of the third database's automatically generated IDs. This is the same whether you're using Packager v5 or v6.

The only way I know of to produce a "dynamic" data upgrade would be using the SQL Comparison SDK to compare your destination database to a backup file of your source database. SQL Packager doesn't (yet) have this functionality.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests