How to Move BarTender System Database or SQL Server Database to a New Computer Server
Overview
While upgrading or migrating the existing computer server to a new system, you may wish to keep all of your existing BarTender log events, records and history data. This can be accomplished by moving your existing BarTender System Database. The following article will guide you on how to move your existing BarTender System Database to a new server.
Applicable to
BarTender 2016 and later
BarTender System Database
Information
The correct way to perform such an operation would be:
1. Download and install Microsoft's SQL Server Management Studio Express (SSMSE).
2. Connect to the original SQL Server and database via the SSMSE. Then, create a full backup of the system database.
4. In The General page, make sure the correct destination database is selected (the database you wish to restore to), and make sure to have selected the correct backup file.
5. In the Options page, choose to Overwrite the existing database.
6. Click on OK to complete the operation. Note that this will completely overwrite the destination database.
Connecting BarTender to the System Database
- Open Administration Console.
- Click on System Database.
- Select the System Database Wizard and click Next in the popup window.
- Select Customize connection settings and click Next.
- Fill in the Server information as well as the authentication credentials and click Next.
- Select your Database settings then click Next and Setup.
- Alternatively, you can review this article to setup your database manually if you don't wish to use the Wizard.
Additional Resources
Generally speaking, so long as your BarTender version and the SQL Server that you are using are both compatible with your Windows operating system that you are using, you should be fine importing your BarTender System Database from an older version of SQL Server. SQL Server database should be backwards compatible. For more related information, please refer to the following articles from Microsoft: