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
