Merge table schema differences

bassofa

Hello guys,
I'm new to Redgate SQL Compare. I'm currently trying to compare two tables in different databases and the action I'll like to take is, if there are differences in the columns in each table, I will like them to be merged into one table with all columns on both tables in one script. Is there a way I can accomplish this? May be an example will help:

Server1.Database1.Table1 has columns (Column 1, Column 2, Column 3) and Server2.Database2.Table1 has (Column 1, Column2, Column 4). I want the deployment after the comparison to have table1 as (Column 1, Column 2, Column 3, Column 4). Is that doable?

AlessandroAlpi

Hi @bassofa,
not with one click, actually. Did you notice the "switch" button between the source and the destination database? You can compare S1.DB1.TB1 (-->) S2.DB2.TB2 applying only the additions/modifications and, then, switch and re-compare with S2.DB2.TB2 (-->) S1.DB1.TB1 only with deploying the additions/modifications. In both the comparison sessions, you must uncheck the "only in the right" objects (deletions).

hope this helps,

sam.blackburn

I think that technique would work for combining tables or other database objects, but not for combining sub-objects such as columns within a table. You might want something like an "ignore column drops" option - there's a UserVoice suggestion for it but it has surprisingly few votes:

https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/3331444-drop