How can we help you today? How can we help you today?

Map objects with similar names

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?
hdomer
0

Comments

2 comments

Sort by
  • 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?
    Linda Hawksworth
    0
  • 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
    David Atkinson
    0

Add comment

Please sign in to leave a comment.