Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

How to set the Shadow database connection

Scott LeWarne Aug 31, 2013 07:50AM AEST

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.

Thanks,
Scott LeWarne

Up 10 rated Down
Daniel Nolan Sep 02, 2013 03:32PM AEST ReadyRoll Agent

Hi Scott,

Unfortunately there isn’t currently a way to do this through the ReadyRoll user interface (although this will change in ReadyRoll 1.7, out later this month), however the Shadow database server can be specified via a project property.

To do so, open your sqlproj file for editing and add the following below the root node:

<PropertyGroup> <ShadowServer>(localdb)\Projects</ShadowServer> </PropertyGroup>

Please note that using a LocalDb connection for the Shadow server may result in Visual Studio shutting down the instance after a certain period of inactivity. You can bring the instance back online by running the following command from a Developer Command Prompt window:

SqlLocalDb start Projects

Alternately, using a local instance of SQL Server Express or Developer Edition will avoid this issue.

Best Regards,

Daniel

This question has received the maximum number of answers.

readyroll.support@red-gate.com
http://assets0.desk.com/
false
readyrollsql
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete