Owners don't match up.
mmaddali
Posts: 3
Hello All,
I am running the latest version of sql data compare (7.1.0.245) on a vista 64 bit machine, and I am trying to compare two remote databases the source database is sql server 2000 database and the destination database is a sql server 2008 cluster database. When I try to compare these two the owners don't match up properly. I even tried to do against a sql server 2005 destination but that had the same issue.
I tried on a 32 bit vista version with no luck.
I was sure that I was able to do this between 2000 and 2005 databases in the earlier versions.
Appreciate all your help.
Thank you,
Murali.
I am running the latest version of sql data compare (7.1.0.245) on a vista 64 bit machine, and I am trying to compare two remote databases the source database is sql server 2000 database and the destination database is a sql server 2008 cluster database. When I try to compare these two the owners don't match up properly. I even tried to do against a sql server 2005 destination but that had the same issue.
I tried on a 32 bit vista version with no luck.
I was sure that I was able to do this between 2000 and 2005 databases in the earlier versions.
Appreciate all your help.
Thank you,
Murali.
Comments
Thank you,
Murali.
This is a strange one. Out of interest, are you able to map your owners manually in the "Remap Objects" tab of the project configuration dialog?
David Atkinson
Red Gate Software
Product Manager
Redgate Software
You can work around the problem in the meantime by going to the Map Owners dialog on the Remap Objects tab and mapping dbo to dbo (and possibly other owners to themselves if you have them).
(Basically, Data Compare started treating users and schemas as different things, which broke the automatic mapping between the dbo user on 2000 and the dbo schema on 2005 and above.)
Redgate Software
It is a pain so I'm just going to start using BCP. This is kinda of a big bug to miss.
David
Redgate Software