Merge two tables

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Merge two tables

Postby jmontani » Thu Jul 05, 2012 6:00 pm

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?
Thx.
jmontani
 
Posts: 1
Joined: Fri Apr 29, 2011 5:24 pm

Postby eddie davis » Mon Jul 09, 2012 2:23 pm

Hi

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests