Skip to main content

Create an Azure SQL metadata 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:


To allow your LiveData Migrator host to connect to the Azure SQL database server, you must create a firewall rule for your LiveData Migrator host's public IP address on the Azure SQL server.

Run the following command on your host to display the public IP address:


For more information on Azure SQL firewall configuration, see Azure SQL Database and Azure Synapse IP firewall rules.

Create a metadata target using access key authentication


The use of the quotation mark character is not supported when included in the SQL Password. See the Known issue for more information.

  1. In the Azure Portal, navigate to the LiveData Migrator resource page.
  2. From the LiveData Migrator menu on the left, select Metadata Targets.
  3. Select Create.
  4. Complete the details under the Basics section:
    • 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.

      Hive Migrator doesn’t support Azure SQL database names containing blank spaces ( ), hyphens (-), semicolons (;), open curly braces ({) or close curly braces (}). Additionaly, see Microsoft's documentation for a list special characters which can't be used.

    • 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 HDInsight to use with the metadata target.
  5. Under Filesystem Details, use the Data Target dropdown to set the default filesystem for the metadata target.
  6. Select Review and create.
  7. Select Create.

If you encounter problems creating an Azure SQL target, see the troubleshooting guide.


See Update authentication settings for information on updating your authentication settings with the UI.

Next steps

Following the creation of a metadata target, you can migrate metadata.