How to Select and Query data between 2 database in different domain?

Question

I am trying to achieve a scenario where i have 2 database say db1, db2. Both the database have same same table tbl1, tbl2 with identical schema.

My Problem is i want to select all data from db1.tbl1 and insert into db2.tbl2. I need to do this with the help of scheduler running every 12 hrs.

Since i am new to sql any reference related to my solution would be helpful.

Any help is appreciated.

May be you want this http://stackoverflow.com/questions/224732/sql-update-from-one-table-to-another-based-on-a-id-match — Rupsingh, Aug 19 '16 at 09:37
Is it possible to Schedule this task when using Linked Server. — Cyber, Aug 19 '16 at 09:56

score 0 · Answer 1 · answered Aug 19 '16 at 09:33

0

Depending on the edition of SQL Server you can try one of Linked Server, SSIS, or Replication

answered Aug 19 '16 at 09:33

Paul Bambury

1,212
1
12
17

How to Select and Query data between 2 database in different domain?

1 Answers1