Share via

Query from Azure server into SQL server

Tim Mullady 221 Reputation points
2022-02-23T14:15:40.447+00:00

Hello,

I wanted to see if someone can help me create a query inserting data from SQL Azure into a different SQL server? I've never done inserts across servers or Azure. I will be writing and running the insert statement from SQL server.

SQL Azure - Server, DB name, username, password

Any help and direction would be greatly appreciated.

Thanks,

Tim

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,786 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,637 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,861 Reputation points MVP
    2022-02-23T16:16:43.227+00:00

    If the number of rows that will be inserted on SQL Server (coming from Azure SQL) is small, then try creating a linked server. See how to create the linked service and insert a row on SQL Server on this article.

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 44,501 Reputation points
    2022-02-25T08:29:02.147+00:00
    0 comments
  3. AaronHughes 391 Reputation points
    2022-02-25T10:13:06.707+00:00

    As above
    Azure External Data Source to the SQL Server that is on Prem
    SSIS package in SQL Server or ADF SSIS runtime

    Extra options
    ADF/Synapse Pipelines could be used to do the same as above in native Copy Activity
    SSMS wizard to move the data if connected to both DBs
    Data Migration tool could be used to facilitate clone of table and data in it to Azure SQL from SQL Server On Prem also

    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.