Merge two tables

jmontanijmontani Posts: 2
edited July 9, 2012 9:23AM in SQL Compare Previous Versions
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.

Comments

  • Eddie DEddie D Posts: 1,666 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.