Help Center>Foundation Help

Moving Foundation databases

Applies to:

These steps are applicable when moving databases for a Foundation environment to a different SQL Server instance or when changing the current SQL Server instance name. Before performing these steps, restore the database from a backup to the new SQL Server instance and ensure all permissions on the original database are reflected on the restored database.

Note: Composer does not use a database. No configuration changes are necessary.

User Governance

  1. As a Central Site Administrator, open the Foundation site in the browser.
  2. Click Settings.
  3. Click Database Connection.
  4. Update the Server Name field.
  5. Click Test Connection. If successful, click Save.

Workflow

  1. As the SharePoint Farm account (the account running the SharePoint timer service), open the Workflow Central Administration site in the browser.
  2. Click Farm Configuration.
  3. Click the Edit icon next to WinshuttleWorkflowConnectionString.
  4. Change the Database connection string to reflect the new SQL Server name.
  5. Click Add.

SAP Integration Server

  1. As the Winshuttle Administrator account, log into the application server.
  2. On the desktop, right-click the Winshuttle Server utility and click Run as Administrator.
  3. Click the Server tab.
  4. Click on the ellipsis to edit the connection string.
  5. Enter the SQL Server name.
  6. Enter the restored database name.
  7. Change authentication to Windows Authentication.
  8. Click OK.
  9. Click Load Configuration.
  10. Click Apply Changes.
  11. Click the Worker tab.
  12. Click Load Configuration.
  13. Perform steps 4 through 8.
  14. Click Apply Changes.
  15. Perform steps 11 through 14 for the Worker (Launch GUI) tab.
  16. Perform steps 1 through 15 on each application server.

License Management System

  1. As the Winshuttle Administrator, log into the application server.
  2. Navigate to the LMS installation directory. The default install location is c:\program files\winshuttle\lms.
  3. Click into the Services folder, and do the following:
    1. Open the web.config file.
    2. Find the <connectionString> node.
    3. Edit the connectionString property in the <connectionString> node by changing the Server and Database values to the restored SQL Server and new database name.
    4. Save the web.config file.
    5. Open the hibernate.cfg.xml file.
    6. Find the connection.connnection_string property.
    7. Edit the Data Source property to reflect the SQL Server name and database name changes.
    8. Save the hibernate.cfg.xml file.
  4. In the Services folder, click into the bin folder, and do the following:
    1. Perform steps 3a through 3h.
    2. Open the Winshuttle.Licensing.WindowService.exe.config file.
    3. Find the <connectionString> node.
    4. Edit the connectionString property in the <connectionString> node by changing the Server and Database values to the restored SQL Server and new database name.
    5. Save the Winshuttle.Licensing.WindowService.exe.config file.
  5. Perform an IISRESET on the server.
  6. Perform steps 1 through 5 on all application servers.