Map objects with similar names
hdomer
Posts: 3
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?
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?
Comments
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?
http://www.red-gate.com/MessageBoard/vi ... hp?t=14113
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software