• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

sql server offsite databases question

MisterServer

Senior member
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
 
Back
Top