Perform post-migration tasks

To prevent issues with database object check-ins after migration, you must complete post-migration tasks. Post-migration tasks differ depending on whether you created the Azure SQL database and schema using the PI Server install kit or the GO.bat script.

Overview of post-migration tasks -- PI Server install kit

If you used the PI Server install kit, you will need to run the /ResetIdentityColumnSeeds parameter using the AF Diagnostics (AFDiag) utility to update the Identity column seeds in the PI AF SQL Server tables.

Overview of post-migration tasks -- Go.bat script

If you used the GO.bat script method, you will need to perform the following tasks:

1. First, update the AF Application Service connect string in the AFServiceconfig.exe file.

2. Restart any PI client applications that point to the AF server after modifying the connect string to reference the cloud-based Azure SQL database.

3. As a final step, use the AF Diagnostics utility to run the /ResetIdentityColumnSeeds parameter.