Last post Nov 22, 2014 04:19 AM by wmec
Nov 21, 2014 01:25 AM|supermanNUM1|LINK
I have one database which is centralized on Cloud and more than 10 database in different location(countries). Some of the country i have to run offline mode which cant access
to cloud database sometime. but night time, i want to synchronize with centralize database with other databases.
What kind of function, shall i use? Can i used c# code or sql agent to do it. OR, any software recommended?
Nov 22, 2014 04:19 AM|wmec|LINK
I think SSIS can be the way for you to schedule relevant jobs that can be calling Stored Proc, to pull data from your central DB to others. Read