how to migrate azure sql database to azure synapse

Question

I would like to migrate standalone Azure SQL database into a schema of the Azure Synapse database. How to achieve this?

Answer 1

You can do this using Azure Data Factory or by creating a pipeline on Azure Synapse (Integrate option) and use the Copy Activity for that. The copy activity allows for schema mapping. This tutorial/article can really help you achieve your goal.