Use SQL backup and restore to migrate to Amazon RDS

Back up and restore is a way to migrate on-premises PI AF data to Amazon RDS for SQL Server. Before you begin, review the official Amazon Relational Database Service (RDS) documentation for an overview of the Amazon RDS back up and restore process: Database Migration Step-by-step Walkthroughs.

Prerequisite

AF Server 2024 R2 is required. You must upgrade to AF Server 2024 R2 before completing the steps in this topic. See PI AF server upgrade.

1. Perform a full database backup of your on premise AF database. See Create a full database backup.

2. Complete the following steps to copy your local back up to Amazon Simple Storage Service (S3), set up the required permissions on the Amazon S3 Bucket, and then restore the backup to your Amazon RDS Instance.

   1. Copy your local backup file to Amazon S3. See Copy backup files to Amazon S3.

   2. Set up permissions on your Amazon S3 Bucket for restoration. See Required Permissions.

   3. Restore the backup from Amazon S3 to your Amazon RDS Instance. See Restore your backup to the target database.

3. Update the AF Application Service connect string in the AFServiceconfig.exe file to point to the Amazon RDS instance. See Modify the AFService.exe.config file.

4. After modifying the connect string, restart any PI client applications that point to the AF server.

5. Open PowerShell or another command line utility.

6. Switch to the %PIHOME64%\AF directory.

7. Enter afdiag /resetidentitycolumnseeds, then press Enter.

   The Identity column seeds are updated in the PI AF SQL Server tables.

   Note: Resetting the Identity column seeds prevents issues with database check-in's.