Wednesday, May 16, 2012 3:29 PM
I am doing a comparison between two databases in order to generate a change script. However, I noticed that it's consistently creating a temporary table, dropping the old table and then renaming the temporary table to the old table's name. What I want is a direct alter of the existing table. Is there any way to do this?
The reason for this is that our SQL policies for these environments require us to alter what is already there and do not allow us to simply drop & recreate everything.
Sr. Software Engineer
Thursday, May 17, 2012 3:11 AMModerator
Do these two databases contain data? If so, I think you have to follow CREATE-COPY-DROP-RENAME (CCDR) strategy the avoid data missing during your deployment or schema comparasion. For further information about Managing data motion during your deployments, please see these two blogs:
And if these two databases do not contain any data, if you would like to generate the ALTER script of your schema compare, you can acheive that by exporting the scripts to the editor or file. Go to Data menu->Schema Compare->Export To->Editor|File. With this option, you will get the change script.
Vicky Song [MSFT]
MSDN Community Support | Feedback to us
- Marked As Answer by Nathon Dalton Monday, May 21, 2012 8:39 PM
Monday, May 21, 2012 7:37 PM
this tool does it right:
its 299$ but it does schema and data in the most efficient way possible