What are the challenges you face when working across database platforms? Take the survey
Options

Merge table schema differences

bassofabassofa Posts: 1 New member
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?

Answers

Sign In or Register to comment.