Options
How to disable "Mapped automatically"?
jansenlam
Posts: 2
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
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
Comments
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
Red Gate Software
US Product Support