Map objects with similar names

hdomer

I would like to map objects between 2 databases that have similar names and hopefully, identical content. For example:

In this database there are these tables:
[Server1].[Database1].[dbo].[Customer]
[Server1].[Database1].[dbo].[Address]

In a different database there are the same tables, but prefixed with "cc_"
[Server2].[Database2].[dbo].[cc_Customer]
[Server2].[Database2].[dbo].[cc_Address]


Is there a way to accomplish this now, or could you allow for this type of mapping in the future?

Linda Hawksworth

I am afraid that SQL Compare does not support custom mapping. I have logged it as a feature request in our tracking system with reference SC-4603. It will be considered for a future release of SQL Compare but it is a large piece of work so I can't guarantee if/when it will be included.

In the meantime, have you considered using the SQL Prompt feature to run Smart Rename on a table to rename objects on Server2:Database2 to the same as Server1:Database1?

David Atkinson

Table mapping is available in SQL Compare 9.5

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

Kind regards,

David Atkinson
Red Gate Software