How to disable "Mapped automatically"?

jansenlam

After I compare two database using SQL Compare 11, at the top of the screen, it stated that 1 of 1 warning: dbo.MyTable: Columns ware mapped automatically.
However, the automatically mapped columns are not what I wanted. I know I can manually unmap the columns, but it required every time after the comparison.

I required exact column name comparison. How to achieve that? Or any workarounds?

Thanks in advance.

Jansen Lam

Allen LeVan

Hello Jansen,

The automatic mapping cannot be disabled but your workflow can be achieved in the following steps:

1. Map the tables and columns how you need them manually
2. Save the project which will include the custom mappings
3. Always load the project with the manual mappings when working on this

Below are some links to documentation on these steps:

http://documentation.red-gate.com/displ ... nd+columns

http://documentation.red-gate.com/displ ... h+projects