Suggestion: Map objects

paulo_morgado · February 21, 2011 6:36AM

In SQL Data Compare I can map owners and objects.

In SQL Compare I can only map owners.

It would be nice to be able to map objects in SQL Compare like it is possible in SQL Data Compare

David Atkinson · February 21, 2011 9:18AM

This is something we've been hoping to do for a while, but unfortunately it keeps missing the cut. Could you describe the use case in which this would be useful to you?

David Atkinson
Product Manager
Red Gate Software

paulo_morgado · February 21, 2011 7:41PM

I ave an application that has a configuration database (menu items, settings, etc.)

In my development machine my database has a differente schema from the QA (and production) database.

The MyTable in QA is the MyTable view on my machine that joins data from MyTableQA (replica of QA's MyTable) and MyTableLocal (local overrides).

This way, I can keep all APIs (SPs, services, etc.) in sync with QA.

Everytime I need to use my local database, I only have to sync with QA, which SQL Data Compares does nicelly.

David Atkinson · February 22, 2011 4:29AM

A workaround would be to compare two views that you create specifically for the comparison. These just need to select from the appropriate tables. As the views would belong to the same schema and have the same name, SQL Compare will map them.

Would this work for you?

David

paulo_morgado · February 22, 2011 4:46AM

No, because I don't want to compare data - SQL Data Compare does a very good job at that.

I want to compare "equal" tables that just happen to have different names.

Can I map Schema1 in one database to both Schema1 and Schema2 in another? I could live with tables with the same name in another schema.

David Atkinson · February 22, 2011 4:53AM

Good question. It might work. Please try to map the schemas using the Owner Mapping tab in the Project Configuration dialog and let us know if this doesn't work for you.

David

paulo_morgado · February 22, 2011 11:36AM

Nope. I would need to map more than one schem on my local database to the same schema on the QA database.

wibblemonkey · September 29, 2011 9:29AM

David Atkinson wrote:

This is something we've been hoping to do for a while, but unfortunately it keeps missing the cut. Could you describe the use case in which this would be useful to you?

David,

I think what I describe here might be a valid use case for this functionality:

http://www.red-gate.com/MessageBoard/vi ... hp?t=14063

Thanks

David Atkinson · November 3, 2011 6:38AM

The SQL Compare 9.5 Beta now has table and column mapping. More information here:

http://www.red-gate.com/MessageBoard/vi ... hp?t=14113

David

Suggestion: Map objects

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk