Create an Azure SQL metadata migration target
Follow these steps to create an Azure SQL target reference to migrate metadata to with LiveData Migrator. Before you start, ensure that you have the following prerequisites:
- An Azure SQL Database in your Azure resource group. This must be initialized for Hive metadata.
- An ADLS Gen2 Storage account and container.
- Network connectivity from your LiveData Migrator host to the Azure SQL database server. See the network guide for more information.
#
Create a metadata target using access key authentication- Create an Azure SQL target with the Azure Portal
- Create an Azure SQL target with the CLI
- In the Azure Portal, navigate to the LiveData Migrator resource page.
- From the LiveData Migrator menu on the left, select Metadata Targets.
- Select Add.
- Complete the Basic details:
- Name: the name of the metadata target as you want it to appear in your list of resources.
- SQL Server: the SQL server containing the database to store metadata in.
- Database: the database to store metadata in.
- SQL Username: the username to log in to the database with.
- SQL Password: the password to log in to the database with.
- HDI version: the version of HDinsights to use with the metadata target.
- Under Filesystem Details, use the Data Target dropdown to set the default filesystem for the metadata target.
- Select Review and create.
- Select Create.
Run the following command to set up an Azure SQL database as a target:
Create a metadata target
See the Azure CLI LiveData Extension - Azure SQL Metadata Migration Target page for help with these parameters.
#
Next stepsFollowing the creation of a metadata target, you can migrate metadata.