I will migrate and update cpr to new server
About this Gig
Server Migration Process for CPR+
Ensure your servers are configured per the guidelines.
CPR+ is a 32-bit application that uses Microsoft SQL Server as a back-end database engine. Please refer to Microsoft for all SQL Server requirements. CPR+ recommends that you are current with all Microsoft Windows updates and service packs.
CPR+ can utilize Microsoft SQL Server 2008 and above. SQL Server needs to be set to "Mixed Authentication (Windows and SQL) Mode".
When standing up a new production environment for CPR+, you make a copy of the production environment database and application file share. You will need to map another drive letter for this environment for temporary testing. Example: Production system is mapped to P:\, NewProduction.
Application Server
SQL Server
Homepath
Connection String
Client Install on Application Server
Report Writer Configuration
DataLink Viewer Installation
File Considerations
Interfaces
CPR Support Required to re-configure the following Interfaces
Interfaces Customer Must Reconfigure
Origin Platform Migration:
Other
Destination Platform Migrations:
Other
My Portfolio
Other Support & IT Services I Offer
FAQ
Whats Type of Database CPR+ uses ?
Microsoft SQL Server
Which SQL versions are supported ?
SQL 2014 SQL 2016 SQL 2019
Can I use express version of SQL ?
Yes, Express version is fully supported as long as the database size is 10GB
Before Installing the Update ??
1-Make a backup of your CPR+ data files and directory. 2-Make sure all users are out of CPR+ Note: It is recommended to reboot the SQL and App servers to improve update performance and free any locked files and resources. Also, stop any services that call on the CPR+ database.
Where can I download a CPR+ update ?
http://update.cprplus.com
Registering Workstation Controls after update
Any workstation that transmits claims (medical, pharmacy, or retrieving ERNs) must have the controls registered after each update.

