SQL Server database synchronization issues

Question

Hello everyone,

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 have 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

Answer 1

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

Answer 2

i think this link will be helpful to you http://msdn.microsoft.com/en-us/library/aa833263%28VS.80%29.aspx