We are evaluating dbForge Schema compare as a replacement tool for generating production deploy scripts for our SQL side of the house. We are comparing against the RedGate product (SQL 2008 version) as we move to SQL 2012.
A few settings I have been looking for and not seeing - wondering if perhaps it is because I have a trial version?
1. wrap entire script in transaction to be rolled back in case of error
2. remove the generated backup of objects at beginning of script
3. add a print confirmation for each object as it is created/modified/dropped
Can anyone tell me if these are tweakable and I am just missing them somewhere?
Cheers
Q's on a few (not so obvious?) features
Re: Q's on a few (not so obvious?) features
My apologies for including item 1 (wrapping transaction). Of course it is included by default.
Re: Q's on a few (not so obvious?) features
This is governed by the "Backup path:" option located on the 'Options' page of the schema synchronization wizard.2. remove the generated backup of objects at beginning of script
There is the 'Include print comments' option on the 'Options' page of the schema synchronization wizard for this.3. add a print confirmation for each object as it is created/modified/dropped