Feature Request - Rename Columns
BrienKing
Posts: 30 Bronze 3
One of the things that may happen from time to time is a column gets renamed. I would like the option to Map Column Names.
Otherwise what I have to do is this:
Add My New Column
Compare the two Tables and Syncronize
Run Script to Populate new Column on Destination Table
Drop Column
Compare the two Tables and Syncronize
If I could just have a Map Column A to B, that would save me a lot of hassle.
Brien King
brien@classic-soft.com
Otherwise what I have to do is this:
Add My New Column
Compare the two Tables and Syncronize
Run Script to Populate new Column on Destination Table
Drop Column
Compare the two Tables and Syncronize
If I could just have a Map Column A to B, that would save me a lot of hassle.
Brien King
brien@classic-soft.com
This discussion has been closed.
Comments
It is possible to map column names in SQL Data Compare if you need to migrate the data easily.
However, this is not possible in SQL Compare, we may consider it for a future release, but no promises.
Regards,
Jonathan
-Project Manager
-Red Gate Software Ltd