Knowledgebase: SQL Updater
Move Entities DB to a different server/instance
Posted by Eric Hanig on 26 June 2015 10:38 AM

Its very easy and straight forward to move the Entities DB (or the Config db) to a different server or instance.

Just take the DB offline and move it as you normally would do.  Then you need to change the setting in a few places.

For Configuration Database

1)  Log into Ion Management Studio

2)  On the Main window, click on Settings

3)  Change the Database server name.

4)  Close Ion Studio and then open it again for the change to take effect.

5)  Do a full deploy out to the servers.

 

For the Entities DB

1)  Log into Ion Management Studio

2)  On the Main window, click on the left tree and expand the enviornments.

3)  Select your top level engine enviornment.

4)  On the right, click the tab for Constants Values

5)  Edit the ENTITIES_DB_CONNECTION_STRING value with the changed settings.

6)  Do a full deploy out to the servers.

7)  Go to the Web site server.

8)  Launch the Web Site Configuration app.

9)  Change the DB settings in here.

(0 vote(s))
Helpful
Not helpful

Comments (0)