NOT RESOLVED: SQL Data Compare Issue: 2000 vs. 2005

Compares and synchronizes SQL database content.

NOT RESOLVED: SQL Data Compare Issue: 2000 vs. 2005

Postby robvon » Tue Dec 30, 2008 7:18 pm

I have the same issue but there is more to it. I have done a schema compare to ensure the DB's are the same (enough anyway). I ignore some changes from tinyint to int and some tables I have changed.

Only a MANUAL mapping can be done. Every table (and I'm talking the IDENTICAL TABLES as per schema) has to be hand selected to match the table which is always next in the list.

The REALLY ANNOYING THING is that every time you go to edit the project it throws the mappings away. Grrrrr. Even if you save the project and try to reload it. Interestingly there is no "Load Project" option....

ALSO, once in the comparison phase I cant set a where clause so that subsequent comparisons always do the whole lot even though you KNOW that 90+% are ok based on the PK being seeded which I could place in a where clause....
Posts: 4
Joined: Tue Dec 30, 2008 7:10 pm

Postby David Atkinson » Wed Dec 31, 2008 2:42 pm


Would it be possible to let us know what version of SQL Data Compare you are using? This will make it easier for us to reproduce your issue and suggest workarounds, if possible.

Kind regards,

David Atkinson
Red Gate Software
David Atkinson
Posts: 1143
Joined: Mon Dec 05, 2005 3:54 pm
Location: Twitter: @dtabase

Postby robvon » Wed Dec 31, 2008 7:30 pm


Only grabbed it last week.

Steps to reproduce:

1. Compare a 2000 syncing to a 2005 version of db's with a few minor schema variations. Most tables are identical. Run it, save it etc then start SQL Compare again so it reloads the project

2. Click compare now from the "Comparison Projects" form. Mappings are gone.

3. Where clause is ALSO gone. Didn't spot that before.

This happens without having to stop and restart as per first post - I just thought this was a clean path to reproduce


Posts: 4
Joined: Tue Dec 30, 2008 7:10 pm

Postby Michelle Taylor » Fri Jan 02, 2009 11:45 am

This is problem SDC-857, which we fixed after had gone out. You can contact for the updated version with the fix. Sorry for the inconvenience.

(The where clause issue might be a seperate problem - we had some trouble with where clauses starting with certain strings. If you still have where clause problems after you've got the patched version, we'll look into that for you.)
Michelle Taylor
Posts: 537
Joined: Mon Oct 30, 2006 11:45 am
Location: Red Gate Software

Postby Chris Auckland » Mon Jan 05, 2009 2:15 pm

The fix version for this issue is If you would like it, please email
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests