Move eB Director DB to another server

Hi Sean,

Please follow the below given steps to restore the database on new server:

1. Restore the database as usual on the new server.
2. Copy the WHOLE directory structure of the repository(ies) to the new machine to the same location it was on the old machine.
3. Using the SMC, create a datasource as you would normally.
4. Click on the datasource in the treeview – you may be told that the database was moved and that the database identifiers must be changed. Walk through the questions (yes on most) so that the ID’s are changed.
5. Run the database update scripts as always.
6. Go to the storage wizard, select the option “Move a repository to the local machine”.

 

Hope this will help you to move Database on to new server, you can ignore steps for repositories as you want to keep it on the same machine.

Hi Sean,

Please follow the below given steps to restore the database on new server:

1. Restore the database as usual on the new server.
2. Copy the WHOLE directory structure of the repository(ies) to the new machine to the same location it was on the old machine.
3. Using the SMC, create a datasource as you would normally.
4. Click on the datasource in the treeview – you may be told that the database was moved and that the database identifiers must be changed. Walk through the questions (yes on most) so that the ID’s are changed.
5. Run the database update scripts as always.
6. Go to the storage wizard, select the option “Move a repository to the local machine”.

 

Hope this will help you to move Database on to new server, you can ignore steps for repositories as you want to keep it on the same machine.

Thank you so much for the response.

What about the communities? Will I have to delete old communities and create new ones?

Yes you need to create new community if ur creating new datasource but if ur using same datasource then you just need to change the server name from all the locations through SMC with the new server name and re run the upgrade script.

Hope that clears the situation.

When only the database server changes ( e.g. due to a new DB environment) and a database instance needs to be moved from one machine to another, you should follow this:
1) in SQL: backup your original DB, restore it on the new DB machine
2) in eB SMC: create a new data source, which points to the database on the new SQL machine
3) in eB SMC: click on "Communities", then on the right side select the affected eB Community, right-click and "Edit Properties" => Assign the new data source
4) eB services need to be restarted - done.

In case FTR is configured, additional steps are necessary.