Migrating CAREWare to a new server requires moving a backup file of the CAREWare data and the business tier settings to the new server, installing a SQL Server Database instance, restoring the database using that backup, and then installing CAREWare on that server.
Here are some things to consider when installing CAREWare on a new server.
We recommend installing the latest version of SQL Server. CAREWare is compatible with the latest version of Windows Server.
To migrate CAREWare to a new server follow these instructions:
-
Create a backup.
-
Move the backup file to the new server.
-
Move a copy of the businesstiersettings.xml from the CAREWare Business Tier folder to the new server.
-
Install the SQL Server Instance.
-
Run the queries here to create the CAREWare database.
-
Restore the CAREWare database using the backup.
-
Set cwbt as the database owner by running the query: Exec sp_changedbowner cwbt.
-
Install CAREWare on the new server by running the installation files here.
-
Stop the CAREWare Business Tier service under local services.
-
Place the businesstiersettings.xml file in the CAREWare Business Tier folder.
-
Update the database connection string by following the instructions here.
-
Once CAREWare is connected to the database follow the instructions here to complete the installation process starting with step 6.
If users attach documents in CAREWare, follow the instructions here to migrate those attachments to the new server.
If users use the SQL PDI in CAREWare, follow the instructions here to migrate the SQL PDI database to the new server.