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:

Create a metadata target using access key authentication#

  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 Add.
  4. 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.
  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.

Next steps#

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