What configuration changes are necessary after migrating the WorldServer Database?

We plan to migrate our WorldServer Database to a new server. The username and password required for database access will remain the same.

Which files and configuration settings need to be updated to point to the new server?

On the server where WorldServer is installed, follow these steps:

1- Open the general.properties file under WS_CONFIG
2- Update the database= property to reflect the new database server location and database name.

Example:
 

# JDBC driver configuration
# MS SQL Server
database_driver=com.idiominc.jdbc.sqlserver.SQLServerDriver
database=jdbc:idiom:sqlserver://wsdata:1433;DatabaseName=worldserver

In this example: 

• wsdata is the name of the database server
• worldserver is the name of the database.

Next, on the server where the File Type Server Support Service is installed, proceed as follows:

1- Open the following two files:

• Sdl.WorldServer.FileTypeSupport.Server.Tools.exe.config
• Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config

2- Search for the <connectionStrings> section within each file.
3- Update the server name accordingly.

Example:
 

<add name="SystemDb" connectionString="Server=EXAMPLE3001;Initial Catalog=EXAMPLE_WS;User Id=EXAMPLE_WS;Password=random4aSK7bum67qY67uq4YmY6aCX4aS67bqG67uY67uD" providerName="System.Data.SqlClient"/>

After these changes, restart both the Idiom/WorldServer Service and the File Type Server Service.
 

This article might be relevant:

WorldServer: How do I update the configuration files with a new database password?