Data Exchange between Azure Sql Server Managed Instance to Azure Sql Server

Copper Contributor

Hi Guru's

 My ask is that we want to migrate only some selected entities and associated attributes from a database hosted on Azure SQL Server Managed Instance to Azure SQL Server.

Can we create a Linked Server on Azure SQL Server and then use Select Into Statement to create tables with the required column names and condition.

SELECT customer_id, first_name, last_name, email

INTO TargetDB.dbo.customers

FROM linked_server.SRC_DB.sales.customers

WHERE state = 'CA';

 

 Here Target DB is the Database on Azure Sql and SRC_DB is Azure Sql Server Managed Instance.

If not then what would be an alternative solution to meet this requirement?

 

Regards

Anu

 

0 Replies