Sql Server Syncronization from one db to another

Question

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?

Anupam Singh · 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 t hen create procedure using linked server and schedule it on job.

Lawrence Pond · Answer

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 Singh · Answer

As per my knowledge replication is not possible in this scenario. But you can schedule job in sql server for the same.

Lawrence Pond · Answer

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 Singh · Answer

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 H ope it will help.