CODEWITHSUNDEEP
sql-serverdatabasesql-server-2008
parth.hirpara
parth.hirpara

Reputation: 542

Data Insertion from one sql server to another

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?

Upvotes: 2

Views: 53

Answers (1)

Kris
Kris

Reputation: 1383

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.

Upvotes: 2

Related Questions