Share via

insert select between two data bases in Azure SQL

Jose Perez 136 Reputation points
2020-11-03T10:20:29.433+00:00

I am looking at moving part of the data from a huge table to another table in another database also in SQL Azure.

This communication is periodic with many frequency

This communication is periodic with many frequency

Thanks

Azure SQL Database
0 comments
Accepted answer
  1. Jose Perez 136 Reputation points
    2020-11-03T13:22:23.93+00:00

    Thanks a lot
    Vaibhav Chaudhary:

    I have done a test and it worked correctly!!

    I have a new question to evaluate the costs that may involve me in performance and budget.

    Is the data in the table located in the source database also stored in the database from which the external table was created?

    Thanks a lot!!!

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,721 Reputation points
    2020-11-03T10:33:14.093+00:00

    One option is to create external table in your Target Azure SQL that points to the table in Source SQL. This way, you run/schedule your INSERT INTO.. SELECT query
    Reference - https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical

    Another options is to use Data factory - Create a pipeline to copy required data and schedule this pipeline

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments

Your answer

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