Compares and synchronizes SQL database content.
Moderators: Chris Auckland, David Atkinson, richardjm, david connell
I want to compare two tables with different names in two separate databases. The columns and data should be identical except my target has an additional column which I would like to avoid.
I see the option to Map the table, but when I highlight the table, the map button remains greyed out.
I have 2 questions:
1. What are the steps for comparing tables with different names
2. How can I filter out the columns I wish to compare.
- Posts: 1
- Joined: Tue Jun 21, 2011 2:53 pm
Thanks for your post.
I'm afraid it's bad news for both questions.
1. There is no way to custom map differently named tables in SQL Compare. It's something we would like to add to the tool, but the problem is that it causes too many issues with dependencies. i.e. every reference to the custom mapped object would also have to be rewritten to the new name.
2. It's not possible to exclude specific columns as they're not treated as objects in their own right. When you compare a table, all columns will be considered.
- Posts: 757
- Joined: Tue Oct 24, 2006 2:12 pm
- Location: Red Gate Software Ltd.
I needed a way of doing this before I had SQL Compare 9, so I wrote a script based on the one here:
http://weblogs.sqlteam.com/jeffs/archiv ... /2737.aspx
I parameterised it so that I could give it two table names and off it would go.
You've probably done this yourself by now... but thought I'd share it!
- Posts: 9
- Joined: Thu Jul 28, 2011 10:54 am
- Location: United Kingdom
Return to SQL Data Compare Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests