I'm trying to merge columns that one database has into a different database but it seems the synchronization tool is providing too much help. For example, given
table A {
a int 4
b int 4
c int 4
}
and
table B {
a int 3
c int 3
}
I want to end up with
table B {
a int 3
b int 4
c int 3
}
When I run the tool, it has the ADD COLUMN b command but also the CHANGE col a and CHANGE col c command. I just want columns in table A that are not in table B to be copied. All others should be left alone. I have all of the hide check boxes checked except for the “To be created in Target.” Can someone please explain my mistake?