Lawrence Pond

Lawrence Pond

  • NA
  • 164
  • 0

Sql Server Syncronization from one db to another

May 18 2014 2:57 AM
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?

Answers (5)