Shadow vs Target Database

atzino

I'm somewhat new to ReadyRoll, but I've used it in the past by editing the scripts directly in the solution. If I want to edit a script (example, alter an existing stored procedure) using SSMS, do I make my changes in the Shadow database or the target database?

ChrisGStevens

You make your changes to the Target database.
In Visual Studio you would use the ReadyRoll to import and generate the new migration script based on the changes it found.
The Shadow database is used for verification of the scripts so no need to modify it as it is created every time you use the sync to view pending changes or import.

Here is more info: https://documentation.red-gate.com/rr1/key-concepts/target-and-shadow-databases

atzino

Got it. Thanks.