How to migrate data from one database to another using Database Migration tool? (4329024)

Active Administrator Database Migration Tool helps migrate data quickly and efficiently from a source database to a target database

For example, you created a new Active Administrator Database and want to copy custom reports and alerts from an existing database

Use the Database Migration Tool to copy the existing data to the new database.

NOTE:

The source and target databases must exist within the same version of Active Administrator

It is recommended that you back up the target database before beginning the migration

To use the Database Migration Tool

1. Stop the Active Administrator Foundation and Active Administrator Notification services
2. Launch the AA Database Migration Tool
3. On the Welcome page, click Next
4. Type the names or browse to locate the source server and database that contains the data to migrate to the target database
5. Type the names or browse to locate the target server and database to receive the data from the source database
6. Click Next
7. Select the data that you want to migrate from the source to the target database
   • To select all the options, click Select all
   • To clear all the selections, click Clear all
8. Click Next
9. Review the selections you made
10. Click Finish
11. After the data migration is finished, you can click to view details about the migration
12. Click Finish
13. Start the Active Administrator Foundation and Active Administrator Notification services