Pre-migration tasks

If you want to migrate your PI Vision database from an on-premises SQL database to Azure SQL Database, first you must complete the tasks listed below.

1. Upgrade to the latest version of PI Vision.

2. Upgrade the on-premises PI Vision SQL database to the latest version of PI Vision following Create and configure your PI Vision database.

3. Make sure that the migrating user has the Required SQL permissions to both the source and destination SQL Servers.

4. Choose which tool to use for the migration. The options are:

   • Azure SQL migration extension for Azure Data Studio - Provides a user interface that walks you through the migration process.

   • Azure Command Line Interface (CLI) - A cross-platform tool that allows you to manage and create Azure resources via the command line.

   • Windows PowerShell - A cross-platform task automation solution that has its own command-line shell, scripting language, and configuration management framework.