Options
Two new Feature Requests
bcpreece
Posts: 47
I have 2 feature requests for compare.
1) Have an option to Ignore Users and Roles. Normally we compare a script location to the production DB to determine what is ready for the next install. We do not put roles and users in the script repository so they always show up as missing.
2) Have a option to ignore the CREATE/ALTER keyword. When we compare code from the script repository we find that some difference is just that the developer saved the script with an ALTER but SQL Compare on the DB side is always a CREATE. If we could ignore that keyword then these scripts would show as identical.
Please let me know if these are possible. I would love to see them in Compare 6.2.
1) Have an option to Ignore Users and Roles. Normally we compare a script location to the production DB to determine what is ready for the next install. We do not put roles and users in the script repository so they always show up as missing.
2) Have a option to ignore the CREATE/ALTER keyword. When we compare code from the script repository we find that some difference is just that the developer saved the script with an ALTER but SQL Compare on the DB side is always a CREATE. If we could ignore that keyword then these scripts would show as identical.
Please let me know if these are possible. I would love to see them in Compare 6.2.
Comments
If you need to synchronize to scripts, and you refer to your users and roles in object permissions, then they may show up in the dependancies list despite being filtered, though. Ignoring them to the extent that they no longer show up as dependancies is more challenging to implement - you're probably better off with a workaround (set up the folder synchronization options to dump users and roles in a folder you don't care about / can delete afterwards when you're synchronizing to the script database).
We considered support for scripts with ALTER instead of CREATE, but it didn't make the cut (we spent more time on non-standard ways of phrasing a CREATE statement instead) and as you're the first customer to mention needing it, it's unlikely to go into 6.2 (which is really just meant to be a patch for checkin/checkout style source control, although it will have a couple of minor bug fixes we couldn't resist putting in). I've noted that we have some demand for the feature now, so if it starts coming up more (or turns out to be really easy to do) we might get it in a future release.
Redgate Software