Dedicated SQL Pool - Can I import a sql server table or a sql server database into azure Synapse dedicated sql pool?

Question

I have existing sql server tables. I would like to archive them in Azure Synapse Dedicated pool as it is said that one can use T-sql to query in Azure Synapse.
My question is:

1. Can I import sql server tables into Azure Synapse ( structure and data )? If yes, how?
2. if #1 answer is positive, Can i query those imported tables using T-sql in Synapse Studio or some other tool?

Thanks!

Answer 1

Hi nguyenhoa-7216

1. You can use Synapse copy data tool to load data into Synapse dedicated sql as described in this link https://learn.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse?tabs=data-factory
   Though, the above link loads from Azure SQL, you can change the source to SQL server.
2. You can query the imported tables with Synapse Studio SQL scripts, SSMS, Azure Data Studio etc.