One of the database systems I work with (I'll call it database A) was essentially sharded into 3 schema-identical copies. This was easy to source control, and when a change was made to any of the copies, it would go to all the copies.
A few months ago a change was made. A new database was created (not sharded, I'll call it database B), and a view was created in database A to reference database B.
The problem is that the view is not the same between the three instances of database A. Database B has 3 schemas: one to match each of the 3 instances of database A. The difference in the view between the three instances is only to point to the different schemas.
We're using TFS2015 to source control. There'd be too big of an undertaking to change this DB structure, but I'm not sure how to source control the view that has to be different between the 3 instances of database A.
Is there a way to source control this without having three copies in TFS?