Options
Renaming tables
einar
Posts: 4
The new version of the database schema has one of the old tables renamed.
When I compare with SQL Compare the new and old DB, SQL Compare wants to drop the old table (I assume I loose all the data then) and create a new table with the new name.
Is there any way to get SQL Compare to handle this situation differently. Can I somehow tell it that the "new" table is just a rename of an old table and thata data should be preserved?
When I compare with SQL Compare the new and old DB, SQL Compare wants to drop the old table (I assume I loose all the data then) and create a new table with the new name.
Is there any way to get SQL Compare to handle this situation differently. Can I somehow tell it that the "new" table is just a rename of an old table and thata data should be preserved?
Comments
If you have Data Compare, you could synchronize the new table across, unchecking the old table so that it is not dropped, and then use Data Compare's table mapping feature to move the data from one table to the other.
Redgate Software
Here is basically a feature request:
When comparing databases, it would be nice to have a table of name equivalences or renames to use in order to determine if two objects are the same.
For example, suppose a database had the MyTable table and associated view misspelled.
MyTabel==MyTable
vMyTabel==vMyTable
Then the synchronizer would recognize the rename, and compare the objects.
This would be better than requiring resync in the UI (like CA ERwin) which requires an annoying number of mouse clicks and does not persist the equivalence. Everytime you refresh the comparison, you have to re-sync the renames. With an equivalence table, you could add more equivalences to the comparison, and then refresh the comparison.
Is such a feature planned?
Redgate Software