How to set the Shadow database connection
Hi, I'm currently evaluating ReadyRoll for use within our company and I have a question regarding the shadow database. Our databases typically already exist as they are created by a data team so I'll be using the process of connecting to that existing database and importing it into the project. When I connect my Target db to that database instance however, it changes my Shadow database to also be stored on that same server. In this case the server is a shared server that usually has space issues and it's going to work if all our or devs end up creating shadow databases for each project they work on within that shared server.
Is it possible to have the Target point to a shared server, but have the Shadow continue to use LocalDB? I couldn't find a specific option for that so wanted to see if it was possible.
Red Gate Software