SQL Server database synchronization issues
I have two SQL Server 2008 Enterprise databases (on two machines), and one of the databases is master database and another database is slave database (master database is read/write, slave database is readonly). I want to ha开发者_JS百科ve daily update from master database to slave database (i.e. new data inserted/updated/deleted in master database could be synchronized to slave database daily or manually controlled). I only need to sync several tables of the databases, not all of the database.
Any solutions or documents?
thanks in advance, George
Another option in is SSIS (SQL Server Integration Services).
Here's a tutorial giving you an overview of what it can do.
The tutorial is for SQL Server 2005 but the concepts remain the same.
You can run the packages manually or they can be scheduled.
HTH
精彩评论