Activity overview
Latest activity by kmart
I'd like to chime-in and also request support for the IF EXISTS feature.
There are 2 main reasons to support this feature:
1. Occasionnaly, some databases receive "private" hot fixes that would create new tables/Sps/Indexes etc.. When the official service pack is published, it fails if any private hot fixes have been previousely applied. This is a major limitation for using red Gate for our purposes and a major source of frustration.
2. The ALTER statement doesn't modify the system creation date for the affected object. Databases are often audited for SOX (and other) compliance purposes and all changes to the databases have to be documented. It it much easier to document such changes when the creation date can be crearly visible at the database level. To take this statement one step further, I'd like to see the option to use DROP/CREATE instead of ALTER for the entire synchronization script.
Thanks,
-Martin / comments
I'd like to chime-in and also request support for the IF EXISTS feature.
There are 2 main reasons to support this feature:
1. Occasionnaly, some databases receive "private" hot fixes that would cre...