Sql Server Syncronization from one db to another
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?