Comments
Sort by recent activity
I talked to red-gate support, and it appears that there is no way to do this gracefully with any of their products. They suggested that we create three scripts:
1. A SQL Compare script that applies the schema changes.
2. A SQL Data Compare script that applies the data changes if 1 succeeds.
3. A SQL Compare script that rolls back the schema changes if 2 failes.
Of course, if script #1 drops a column then the data in the column is lost if script #3 needs to run. Looks like there is no way to do this with a single script. We have to run the SQL Compare script, and then run the SQL Data Compare script ONLY if the first script had no errors. / comments
I talked to red-gate support, and it appears that there is no way to do this gracefully with any of their products. They suggested that we create three scripts:
1. A SQL Compare script that applie...
I'm not sure where this was left? We are using SQL 2005, but need scripts to be generated taht are supported on SQL 2000. Is our only option really to install a SQL 2000 instance somewhere to use for our synchronizations? / comments
I'm not sure where this was left? We are using SQL 2005, but need scripts to be generated taht are supported on SQL 2000. Is our only option really to install a SQL 2000 instance somewhere to use...