Red Gate forums :: View topic - Merge two tables
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Merge two tables

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 29 Apr 2011
Posts: 1

PostPosted: Thu Jul 05, 2012 6:00 pm    Post subject: Merge two tables Reply with quote

Is it possible to merge two tables?
Let say I have table A with columns A; X; Y and Z and table B with columns B; X; Y and Z.
When synchronizing from table A to table B column A is going to be added but column B is going to be dropped.
What I want is to keep column B in table B and just add column A.
Is there anyway to do so?
Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Mon Jul 09, 2012 2:23 pm    Post subject: Reply with quote


Thank you for your post into the forum.

Unfortunately what you are seeking cannot be achieved within SQL Compare. SQL Compare does not perform any merging process, it is designed to compare two data sources and make them identical.

The only work around I can think off is to use SQL Compare to perform the comparison. Generate a deployment script and modify it to suit your needs.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group