Red Gate forums :: View topic - NOT RESOLVED: SQL Data Compare Issue: 2000 vs. 2005
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

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

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
robvon



Joined: 30 Dec 2008
Posts: 4

PostPosted: Tue Dec 30, 2008 8:18 pm    Post subject: NOT RESOLVED: SQL Data Compare Issue: 2000 vs. 2005 Reply with quote

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....
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Wed Dec 31, 2008 3:42 pm    Post subject: Reply with quote

Hi,

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
Back to top
View user's profile Send private message Send e-mail
robvon



Joined: 30 Dec 2008
Posts: 4

PostPosted: Wed Dec 31, 2008 8:30 pm    Post subject: Reply with quote

Version 7.1.0.245

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

Regards

Rob
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 525
Location: Red Gate Software

PostPosted: Fri Jan 02, 2009 12:45 pm    Post subject: Reply with quote

This is problem SDC-857, which we fixed after 7.1.0.245 had gone out. You can contact support@red-gate.com 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.)
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Jan 05, 2009 3:15 pm    Post subject: Reply with quote

The fix version for this issue is 7.2.0.4. If you would like it, please email support@red-gate.com
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group