Azure synapse migration

Anandazure 46 Reputation points
2021-11-08T18:09:42.867+00:00

We are doing the migration from SQL database to Azure synapse. Here we need to

1.create tables in sql server management studio
2.inserting data into tables
3.And we have to update the tables

For above those three how to write SQL code in SSMS.

Azure Database Migration service
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,639 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 53,531 Reputation points Microsoft Employee
    2021-11-09T05:56:35.44+00:00

    Hello @Anandazure ,

    Thanks for the question and using MS Q&A platform.

    In this article, we will help you to learn different methods that are used to update the data in a table with the data of other tables. The UPDATE from SELECT query structure is the main technique for performing these updates.

    In order to migrate your SQL DB to Azure Synapse Analytics, you need to plan your migration including schema and data assessment to ensure it is compatible with Azure Synapse. Also, in order to migrate your data you need to look into Migrate your data documentation.

    Additionally, dedicated SQL Pools support various loading methods include BCP, SQLBulkCopy API however Polybase external tables and the Copy statement are much faster and scalable way to load the data.

    Azure Synapse Pathway helps you upgrade to a modern data warehouse platform by automating the code translation of your existing data warehouse. It's a free, intuitive, and easy to use tool that automates the code translation enabling a quicker migration to Azure Synapse Analytics.

    147633-image.png

    For more details, refer to Azure Synapse Pathway overview.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators