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.

    Monday, April 19, 2021 6:24 AM
  • Here are some following steps:


    • Start with SQL Server Management Studio to connect to your SQL pool in Azure Synapse Analytics & run some (T-SQL) commands.

    • Create a separate database there

    • Create a new table in that database

    • Insert rows into the table

    • Query the new table & view the results

    • Use the query window table to verify your connection properties

    Thank you

    Friday, April 30, 2021 2:47 PM
    1. If you want to import the bulk data, then use OPENROWSET(BULK...) commands.
    2. Connect to a dedicated SQL pool in Azure Synapse Analytics.
    3. Create a database.
    4. Create a table in your new database.
    5. Insert rows into your new table.
    6. Query the new table and view the results.
    7. Use the query window table to verify your connection properties.
    8. See this website for more information:- https://www.bestscourses.com/Programming/SQL-query-online-training/
    Monday, May 3, 2021 12:12 AM
  • Maybe Ispirer MnMTK could help? It supports a large list of source databases that may be deployed to Azure Synapse Analytics.
    Friday, July 2, 2021 8:51 AM