Source control server configurations

[AndrewBA]

Hi All,

Has anyone come up with a way of source controlling server configurations? For example, I have just enabled file stream access on my dev machine and would like to be sure that this setting is not missed during deployment. We're using SVN at the moment but are actively moving towards TFS.

Can Redgate Source Control 2 monitor this?
Is there a method of deployment that will incorporate server configurations?

Any help will be most appreciated

Cheers
Andrew

[james.billings]

Currently this isn't possible unfortunately. We only really look at object level settings rather than server level.

There's an existing feature request for the SQL Compare engine to support this, but I'm not sure if/when it's likely to be implemented. If it is, then potentially SQL Source Control could take advantage of course.

If the feature is important, please feel free to suggest it on our Uservoice: http://redgate.uservoice.com/forums/39019-sql-source-control

It's a good way to gauge if a lot of other customers would find the feature useful, so things can be prioritised appropriately.