Converting an Enterprise server's data sources

If you have upgraded an Enterprise server to a later version, 'Convert Required' appears on the Enterprise server's card on the Servers page and a Convert link appears beneath the server. You use the Convert Datasources in Server page to convert the server's data sources to the same version as the server before you can use them. As each data source in Server Admin is linked to a Microsoft SQL Server database, converting a data source means converting the SQL Server database to which it is linked.

To access the Convert Datasources in Server page, on the Servers page, click Convert underneath the Enterprise server whose data sources you want to convert.

When you convert an Enterprise server's data sources, the existing SQL Server databases are not changed; the data within them is copied into another database and converted. This means that you can downgrade an Enterprise server back to an earlier version if necessary - the earlier versions of each data source's databases are still available.

Before you convert an Enterprise server's data sources, you must create new databases in SQL Server - one for each of the Enterprise server's data sources. The data from the existing databases will be copied into these new databases and converted.

To convert an Enterprise server's data sources to the same version as the server:

Create a new database in SQL Server for each of the Enterprise server's existing data sources. Give these databases appropriate names, and make a note of them. It is good practice to give them names that include the version number to help you differentiate between databases that relate to different versions.
In Server Admin, on the Servers page, click Convert underneath the Enterprise server whose data sources you want to convert. The Convert Datasources in Server page appears.

This page displays the selected Enterprise server's data sources in a table. The From SQL Datasource column displays the name of the current SQL Server database for each data source. The To SQL Datasource column displays a suggested name for the new SQL Server databases that will be created when you convert the data sources.
Enter the names of the databases you created in step 1 in the To SQL Datasource column, overwriting the suggested names.
Click Convert. As the data sources are converted, a progress bars show you the progress of the conversion.

When the data sources have been converted, you can start the Enterprise server.