Use Azure Database Migration Service

You can migrate a PI AF database to Azure SQL Database or Azure SQL Managed Instance using the Azure Database Migration Service.

1. Sign in to the Microsoft Azure portal.

2. Navigate to Azure Database Migration Service: Select All Services, select Migration on the left pane, then select Azure Database Migration Services.

3. Create a Database Migration Service instance or reuse an existing instance that you created earlier.

   Note: For instructions on creating an offline version of an on-prem database, see Tutorial: Migrate SQL Server to Azure SQL Database (offline).

4. Select the database migration service instance, then select New Migration.

5. If an integration runtime has not been configured, select Configure runtime settings, then follow the instructions to create one.

6. In the Select new migration scenario screen, make the following selections:

   • Source server type: SQL Server

   • Target server type: Azure SQL Database or Azure SQL Managed Instance

     Note: Offline migration mode is automatically selected since it is the only supported Azure SQL Database mode.

7. Select Select.

   The Azure SQL Database Offline Migration Wizard opens.

8. Enter the source server name and connection information for your on-prem PI AF SQL Server database.

9. Select Next, then select Databases for migration.

10. Select the checkbox next to your on-prem PI AF SQL Server database.

11. Select the Next: Connect to target Database.

12. Select your target cloud-managed database server and then enter the connection information.

13. Select Next: Map source and target databases.

14. Select your target cloud-managed database from the dropdown list, then select Next: Select database tables to migration.

15. Select the Select all tables checkbox.

16. Locate and then unclear the System ID table checkbox to ensure this table is not migrated.

    Note: The System ID table contains the name of the AF server, which may no longer be correct if it was moved to a different machine. Any tables that are empty will be unselected and cannot be migrated.

17. Select Next: Database migration summary.

18. Review your selections, then select Start Migration.

    Migration status is shown on the Azure Database Migration Service instance screen.

    After migration has completed successfully, your on-prem PI AF SQL Server data is now available in Azure SQL Database.