Data Insertion from one sql server to another

Question

I am working on Microsoft SQL server databases. I have a base database and a application database. What I want to push some data (using query) from application db to base database on some specific time period. Is this can be achieved by db procedure?

Both database are at different location in context of IP. Is there any way for connection between db at DB level?

@parth.hirpara, http://stackoverflow.com/questions/189422/how-do-i-create-and-query-linked-database-servers-in-sql-server — Kaushik Maheta, Nov 23 '15 at 07:05

score 2 · Accepted Answer · edited May 23 '17 at 11:53

2

Use a linked server:

How do I create and query linked database servers in SQL Server?

As for running the query on a timer, you can do that with an agent, or from within your application, or a scheduled task, etc.

edited May 23 '17 at 11:53

Community

1
1

answered Nov 23 '15 at 06:37

Kris

1,336
11
16

Data Insertion from one sql server to another

1 Answers1