none
how to import tables from SQL Managed Instance to Azure Synapse Analytics RRS feed

  • Question

  • I tried importing table by SSMS import/export wizard, but it took so much time doing as 20minutes per 20MBytes.

    What is the data-migration best practice from SQL Managed Instance to Azure Synapse Analytics?

    Thursday, March 18, 2021 5:25 AM

Answers

  • Check out this :

    https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-managed-instance

    https://docs.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-azure-synapse-analytics?view=sql-server-ver15

    • Marked as answer by Inoway Tuesday, March 30, 2021 1:09 AM
    Sunday, March 21, 2021 5:58 PM

All replies

  • Check out this :

    https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-managed-instance

    https://docs.microsoft.com/en-us/sql/ssms/quickstarts/ssms-connect-query-azure-synapse-analytics?view=sql-server-ver15

    • Marked as answer by Inoway Tuesday, March 30, 2021 1:09 AM
    Sunday, March 21, 2021 5:58 PM
  • Follow the steps to Provision an Azure Active Directory administrator for your Managed Instance.
    Create logins for the Azure Data Factory managed identity. In SQL Server Management Studio (SSMS), connect to your managed instance using a SQL Server account that is a sysadmin. In master database
    Create contained database users for the Azure Data Factory managed identity. Connect to the database from or to which you want to copy data
    Grant the Data Factory managed identity needed permissions as you normally do for SQL users and others. Run the following code
    Configure a SQL Managed Instance linked service in Azure Data Factory.
    Wednesday, March 31, 2021 6:31 AM
  • Follow the steps to Provision an Azure Active Directory administrator for your Managed Instance:


    1. Create logins for the Azure Data Factory managed identity. In SQL Server Management Studio (SSMS), connect to your managed instance using a SQL Server account that is a sysadmin. In master database.


    2.Create contained database users for the Azure Data Factory managed identity.

    3.Connect to the database from or to which you want to copy data
    4. Grant the Data Factory managed identity needed permissions as you normally do for SQL users and others.

    5. Run the following code
    6. Configure a SQL Managed Instance linked service in Azure Data Factory.

    9 hours 46 minutes ago