Home > IT Answers > Business Intelligence > Data Synchronization
Pragmaticna
0 pts.
 Data Synchronization
Data synchronization
For a daily data synchronization between (MS SQL SERVER 2000) central and local database (local dB has same schema as central dB but some tables in local dB will stay empty and out of data synchronization), what is the better solution: 1. Using the daily back-up, transfer of back-up file to local site and restore option on local site Or 2. Transactional Replication option Thanks

Software/Hardware used:
ASKED: September 27, 2007  3:54 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _