Share via

How automate copy BD from GCP to Azure SQL Server?

García,Yaser,CL-Santiago,External 0 Reputation points
2024-03-21T20:16:27.5766667+00:00

I have my DB on GCP, i want to copy only a few o all tables to a BD in Azure SQL Database, and to be automated once a day. I have researched but have not been able to find anything.

Azure SQL Database
SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
    2024-03-22T00:08:12.7366667+00:00

    @García,Yaser,CL-Santiago,External

    Thank you for reaching out.

    You can try out ADF if your source data is one of the sources listed in the screen shot below.

    Google Ads, Google BigQuery,Google Cloud Storage.

    User's image

    In ADF, you can create a pipeline by using a trigger to run daily at the desired time. Pipeline execution and triggers in Azure Data Factory or Azure Synapse Analytics

    Please let me know if you need more details.

    Regards,

    Oury

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.