- Dec 29, 1999
- 271
- 0
- 71
Work has 3 offsite manufacturing companies that each run their own SQL server database for production purposes. What would be the best way of pulling the data from these databases into a centralized onsite SQL server by way of an automated procedure. Right now the info is backed up daily locally on each of the offsite servers with a SQL agent job and then manually transferred/imported over to the onsite server every week. This is obviously tedious and not synchronized(?) in data so if it was automated this would help alot. Can anybody recommend an appropriate method of doing this or if it is even possible? thanks
