What is the recommended approach for renaming a column with SQL Change Automation?
We attempted to rename a column in the SQL Change Automation Pre-Deployment script, but it looks like the final script that SQL Change Automation generates for the migration is based on the old column names and not on the new column names that were changed in the Pre-Deployment script. Is there a recommended approach for renaming a column? Does this rename have to happen on the target database before SQL Change Automation is run since it looks like Smart Rename just generates a script that is be run against the target database?
0 · Share on Twitter