How can we help you today? How can we help you today?

Shadow vs Target Database

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?
atzino
0

Comments

2 comments

  • 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


    ChrisGStevens
    0
  • atzino
    Got it. Thanks.
    atzino
    0

Add comment

Please sign in to leave a comment.