SQL INSERT INTO SELECT Statement between two different databases

Question

sometimes I need to move data from one database table to another table in different database. These tables are identic. So I am trying to make program in C# Winforms, but I cant figure it out. I think that I should use this:

INSERT INTO table2
    SELECT *
    FROM table1
    WHERE condition;

But how can I execute this sql command when I need two connections? Or what is the right approach?

EDIT: They aren't on same server. Any other option than throught Linked servers?

If you need to do this more than a trivial amount: purchase a tool designed to synchronise data between databases. They may appear to cost a lot, but that will be cheaper than your time. — Richard
– Richard, Commented Oct 11, 2018 at 10:08

Yogesh Sharma · Accepted Answer · 2018-10-11 10:04:18Z

3

If two databases have the same server, then you can do :

INSERT INTO [dbname].[schema].table2 (<column list >)
     SELECT * 
     FROM [dbname].[schema].table1
     WHERE condition;

answered Oct 11, 2018 at 10:04

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Richard Over a year ago

Or, if on another server: linked servers.

Kali26 Over a year ago

They aren't on same server. I forget to mention. Is linked servers the only one possibility?

Yogesh Sharma Over a year ago

@Kali26. . . Yes linked servers could be possible solution for this.

SE1986 · Accepted Answer · 2018-10-11 10:08:31Z

0

In addition to Yogesh's answer, if the databases are on separate servers, you will need to set up a linked server

answered Oct 11, 2018 at 10:08

SE1986

2,7901 gold badge15 silver badges34 bronze badges

Collectives™ on Stack Overflow

SQL INSERT INTO SELECT Statement between two different databases

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related