How do I change the database instance where CAREWare is located?

RSS

» How do I change the database instance where CAREWare is located?

The swapping of databases should only be done by those familiar with SQL commands and aware of all possible issues which may occur. You will need a SQL manager such as Enterprise Manager or Craig’s SQL Manager.

Go to the CW_Setup directory located at C:\CW_Setup.
Run RWCAREWareInstaller.exe.
Select “Custom Install” and press “Next”.
Select the second check box and press “Next”.
Provide a SA password and instance name for the new instance (CAREWare2).
The installer will then create the new database and start the service. Once the service is started, you will see a new window that reads ‘The data tier has been successfully installed.’
The radio button for creating a BusinessTierSettings.xml file will be checked; UNCHECK this button and press "Finish".
Go to the business tier directory located at C:\Program Files\CAREWare\RW CAREWare Business Tier and open the CW Admin.exe.
Click "Stop Server".
Go to the "Services" tab and stop both SQL Server services by highlighting each and pressing "Stop Service".
Go to the old database instance directory (default location: C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE\Data).
Highlight CW_Data.MDF and CW_Data_log.LDF and then press control (CTRL) + C. This will copy both files.
Go to the new database instance directory located at C:\Program Files\Microsoft SQL Server\MSSQL$CAREWARE2\Data.
Press Control (CTRL) + P. This will paste both files in to this directory. If prompted to overwrite files, click "Yes".
Go back to the CW Admin.exe and start MSSQL$CAREWare2 on the "Services" tab.
Go to the "Server Settings" tab and highlight the tag DatabaseConnectionString and press "Edit".
Change CAREWare2 to CAREWare3 and then press "Save".
Press "Start Server".
Open Craig's SQL Manager and register the new database (Right click on SQL Server Instances and select "Register new instance". Then click "Find BusinessTierSettings.XML" button and browse to the RW CAREWare Business Tier directory where the XML File is located. Select the file and press "Open". Once the path to the business tier is provided click "Connect".)
Expand CAREWare2, then expand CW_Data, then expand Tables.
Select the table CW_Client and right click on it. Then select "Run a query".
Delete any text which may appear in the new query window.
Paste this query into the query box: exec sp_changedbowner 'cwbt'
Click "Run Query".
Go back to the CW Admin.exe and click "Stop Server".
Once the service is stopped click "Start Server".
Open CAREWare and attempt to login.

Back to the Business Tier

Back to Frequently Asked Questions