Switch to local database MVC application

Question

Since I've got a local copy of my database server, I would like to change the server IP address in hosts file and point it to the local database. Is there any way of doing this without having to amend any piece of code?

change connection string based on where you want to connect. use web.debug.config to do that — harishr
– harishr, Commented Sep 29, 2015 at 8:28
That's what the config is for, just change your connection string. If you really want to fake a host, what have you tried? Editing your hosts file is documented very thoroughly on the web. — CodeCaster
– CodeCaster, Commented Sep 29, 2015 at 8:29

Richard Seal · Accepted Answer · 2015-09-29 08:36:30Z

2

Change the connection string in your web.config.debug file

You can change it using the xdt:Transforms Like this:

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
  <connectionStrings>
    <add name="name" connectionString="local connection string here" xdt:Transform="Replace" xdt:Locator="Match(name)" />
  </connectionStrings>
</configuration>

answered Sep 29, 2015 at 8:36

Richard Seal

4,26616 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

m5c · Accepted Answer · 2015-09-29 08:42:39Z

1

It depends on how you've coded the application. If you have created the connection string inside the application , they you would need to change code . Or if the settings are in a config file . editing the config file should be enough.

If you have changed the host entry , check if the IP itself is accessible and the specific port is open or not.

Also do you need to authenticate differently ? Posting the stack trace might be helpful.

answered Sep 29, 2015 at 8:42

m5c

5678 silver badges13 bronze badges

Collectives™ on Stack Overflow

Switch to local database MVC application

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related