Sep 13, 2022
This document outlines the steps needed to transfer the AIUniversal and AIUEvent databases from one SQL Server instance to another. If moving the actual application server from one machine to another see the Migrating Access It! Universal.NET To A New Server article.
- Open the Service Manager (Start | Programs | Access It! Universal.NET | Utilities)
- Select Start Server Process
- Open the Database Configuration Utility (Start | Programs | Access It! Universal.NET | Utilities)
- Click Connect to Database
- Click OK
- Click Backup/Restore
- Select the Backup File Location where the backup files will be created
- Click Backup Now
- When the status windows reports Backup Complete close the Database Backup/Restore window
- Close the Database Configuration Utility
- Transfer the newly created backup files to the new SQL Server machine (if machine is separate from current instance)
- Open the Database Configuration Utility (Start | Programs | Access It! Universal.NET | Utilities)
- Click Connect to Database
- Enter connection information for new SQL Server instance
- Click OK
- Click OK when prompted to create a new database
- Click Backup/Restore
- Click Restore Database
- Select the AIUniversal.bak file
- Click Open
- When the status window displays Finished With Restore close the Database Backup/Restore window
- Close the Database Configuration Utility
- Open the Service Manager (Start | Programs | Access It! Universal.NET | Utilities)
- Select Start Server Process
- Launch Access It!