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
2. Transactional Replication option
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!