Any way to automatically link multiple databases to SQL Source Control? Work with SQL High Avail?

Vivian

Is there an automatic way to link multiple databases to SQL Source Control to save developers time to having to set up the link one database at a time?

Also, any recommendations on using SQL Source Control with SQL High Availability groups? Do I need to link databases to SQL Source Control for both primary and secondary servers in the High Availability groups independently?

Tianjiao_Li

Hi @Vivian

Currently, it's not possible to automate linking multiple databases to SQL Source Control, unfortunately. We have got a feature request like this one so please kindly cast your vote on it or create your own one on our user voice forum.

We don't expect SQL Source Control to be used with HA groups since it should be used with development tools only. May I check with you what kind of operations you'd need SQL Source Control in HA groups? 

Thanks.