Activity overview
Latest activity by mdp2176
CLI - How to exclude single column from sync
Using the CLI, how do you exclude a single column from the synchronization? I see plenty of examples of how to exclude a table, but not a single column in a table.
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...
Support for Drop If Exists
The following topic was locked, but I don't see where there is any resolution to the issue. Is this going to be added to the product any time soon?http://www.redgate.com/messageboard/vie ... 6b5e7...
Why do scripts not put owner create statements for sprocs?
I've read all the posts on comparing objects with different owners, and that is fine. But how come the resulting SQL from SQLCompare does not put the object owner in the create statement for store...
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...
How to combine SQL and Data scripts into single transaction
We need to be able to create upgrade scripts that change both schema and data. The data changes are dependent on the schema changes, and the schema changes cannot be applied without the data chang...