Activity overview
Latest activity by Yonger
We'd like to do this just to save a little bit of time. We currently have a manual process for releasing a new version of our software...
1) Create a snap shot of the database as it is now
2) Create a SQL script to create the database as is in a blank database for new installs
3) Then create a SQL script to upgrade a database in the pervious version
to the database as it is now based on the snap shot created for the last
version
I've been tasked with creating something to simplify this process. The first two I can do easily based on the examples using SQLCompare.exe. The third item though may need human interaction. We're woried that there may need to be some data migration done on an upgrade script so we want to make sure that these scripts will always be verrified. Seems that the best solution would be to do the first two steps automatically then create a project and then open the SQL Compare UI right to the project. That way we can just hit a button..have the first two steps happen.. have the UI come up...make any changes needed by hand..then hit the button to create the upgrade script. If not possible to have it open directly to the project I will just have it open the UI and direct people to open the correct project. / comments
We'd like to do this just to save a little bit of time. We currently have a manual process for releasing a new version of our software...
1) Create a snap shot of the database as it is now
2) Crea...
Launch a comparison project in UI from Comand Line
I searched the forums and help but could not find an answer to this. I'm trying to simplify the process of generating our SQL scripts but still want to make sure that change scripts are verified. ...