changing database server for a compare
kdean
Posts: 2
I have projects setup in sql data compare 8 for a specific sql server for example: server1 compared with server 2 and i have several tables and fields manually mapped since the table names and field names are different in the servers.
Is there a way I can change the server that is being compared and not have to remap everything again?
compare server1 to newserver2?
newserver2 has the same tables as server2.
also the same for tables. compare table1 to table2. then compare table1 to newtable2 without remapping the fields.
newtable2 has the same fields as table2.
thanks.
Is there a way I can change the server that is being compared and not have to remap everything again?
compare server1 to newserver2?
newserver2 has the same tables as server2.
also the same for tables. compare table1 to table2. then compare table1 to newtable2 without remapping the fields.
newtable2 has the same fields as table2.
thanks.
Comments
I am afraid that this isn't possible with the tool, however can I suggest that as a workaround you set up all of your mappings and them save these as individual project files? This means that you should be able to come back to them at a later date, and providing there hasn't been any underlying schema changes, your mappings will still be kept in the project file.
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569