locked
is there any example of usage data-factory to keep mysql database data and then restore from it via the python sdk api ? RRS feed

All replies

  • When you say "dump and restore" do you  mean backup and restore ? Can you please elaborate more on the business scenario here .

    Thanks Himanshu

    Friday, August 9, 2019 5:26 PM
  • i want to take mysql server in database in azrue save it to datafactory and restore it back to azure database 
    Sunday, August 11, 2019 5:32 AM
  • specify i followed this tutorial https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-python  and i want to upload directly from mysql server in azure using AzureMySqlLinkedService .
    Sunday, August 11, 2019 6:14 AM
  • Thanks , As we understand  you need to migrate  MySql DB to Azure using ADF . Well we do not have  any code sample in Python , but you can use the copy tool to do the work . Please have a look on this  . In the blog they do talk about SQL Server , but it should work with mysql also . 

    You can also use ADF UI for authoring the logic , I suggest you to please look into this document 

    Since you are migrating the data from in-premise to Azure you also need to install IR . Please read about this here .

    Link : https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-copy-data-tool

    https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-portal

    Do let me know how it goes .


    Thanks Himanshu


    Monday, August 12, 2019 8:35 PM
  • Just wanted to check if the issue is resolved and if yes it will great if you can post the resolution here .

    Thanks Himanshu

    Wednesday, August 14, 2019 8:51 PM