This week I decided to focus on a few suggestions revolving around automation and making certain tasks easier to script or deploy. The first one that came to mind was a recent request from Nicholas Cain (blog | twitter), asking for a SCHEMA_ONLY backup option – to make moving a database *without* the data a much easier process:
A few years ago I asked for an easier way to generate DDL such as CREATE TABLE from existing objects. You can do this using the UI, or by querying against a whole slew of catalog views, but it is very cumbersome. Metadata discovery enhancements in Denali make some parts of this task easier, but not all of them.
A similar suggestion is this one from "SQLpro," who asks for a way to easily copy (not move) objects from one schema or database to another. This can be very handy if you want to test minor changes to a whole slew of objects in an isolated place.
Next, Steve Jones (blog | twitter) asks for a way to initiate a full backup from a snapshot. This would allow you to later decide if you want to "start over" from the state at the time of the snapshot, or to restore elsewhere a very specific point of time in the database without having to deal with transaction logs and true point-in-time restore.
And finally, one thing I certainly thought would make the list for Denali but didn't, was RegEx support. Currently it is quite a pain to implement RegEx – everyone has to deploy CLR to all of their servers, and everyone is writing their own RegEx methods with different functionality etc. It makes for a very disconnected development experience, especially for those of us working in different environments (some of which don't allow CLR). Simon Sabin (blog | twitter) and others argue that simply passing the buck to CLR is not a viable answer for all customers:
Here are some other requests for RegEx… and while I normally don't advocate duplicates because it just dilutes the votes, they're all still active, so it can't hurt to vote for ALL of them: