We have a database project in TFS which lives in its own solution and has Dev, UAT and Prod branches. The project includes many different schemes which reside in one DB once deployed.
A decision was made to move one of the DB schemes entirely into its own DB, therefore I will have to create a separate solution and project for that schema.
How can I do that in TFS so that the existing history of every object is preserved after this migration?
Here's what I currently have:
MyDB_Dev
SchemaToMove
SchemaToStay
MyDB_UAT
SchemaToMove
SchemaToStay
MyDB_Prod
SchemaToMove
SchemaToStay
Here's what I need to arrive at:
ANewDB_Dev
SchemaToMove
ANewDB_UAT
SchemaToMove
ANewDB_Prod
SchemaToMove
MyDB_Dev
SchemaToStay
MyDB_UAT
SchemaToStay
MyDB_Prod
SchemaToStay