Automatically link multiple databases in an instance or share config with team

I'm in the process of migrating from one machine to another and its a huge PITA because of SQL Source Control. So far the only way i've found to move my config over is to copy the entire SQL Source Control 7 settings folder in AppData\Local over to my new machine. (500MB compressed, 2.5GB uncompressed)

Relinking the databases just isn't reasonable. I have 120+ databases across dozens of servers linked, and I haven't even linked all of our databases yet. Everytime we on board someone to the team they have to add each one as they go. This mostly works, but they inevitably forget to link a server and thus check in their changes quite a bit.

I wish SQL Source Control would allow you to share Linked Server config. Or could allow you to define a source control path format so you could link all databases on an instance.

Comments

Sign In or Register to comment.