Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |