Answered by:
how to import tables from SQL Managed Instance to Azure Synapse Analytics

Question
-
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
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
-
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. -
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.