Sql Server Syncronization from one db to another

Lawrence Pond

12y1.3k

I have a third party product that my company host in SQL Server Database. Over time we have needed to add some of our data and want to use some of the third party data so we have a service that pulls data from various tables on a time interval and then load them in another database that was constructed by my company.

Rather than using a service to pull the data from one databasse to another on set intervals does Microsoft have any tools that do this? To me this seems like a utility that sql server might have to all another sql server database to pull data on some scheduled timer?

Any ideas on how to do this?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anupam Singh12y ago
Accepted answer
yes, that was what i mean.

of course you can connect sql server different instance using linked server.

find the steps here http://sqlserverplanet.com/dba/how-to-add-a-linked-server

then create procedure using linked server and schedule it on job.
Lawrence Pond12y ago
Hi Anupam, What about doing something like this writing the code in a stored procedure? would it be possible for a stored procedure to access tables in another database and insert the data in one of its tables? Also if this is true how would I schedule this to be ran on ## minute intervals.
Anupam Singh12y ago
As per my knowledge replication is not possible in this scenario.
But you can schedule job in sql server for the same.
Lawrence Pond12y ago
My problem is this is not a direct table copy from one directly to another the new source tables are composite tables with some columns from one table and other columns from another table. Is this possible with they sync tool?
Anupam Singh12y ago
Hi Lawrence,

Yes, sql server has a great feature called Replication.You can achieve the same using Replication here is the step by step process described

http://www.codeproject.com/Articles/715550/SQL-Server-Replication-Step-by-Step

Hope it will help.