CODEWITHSUNDEEP
sql-server-2008
George2
George2

Reputation: 45801

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

Upvotes: 2

Views: 1446

Answers (1)

Ralph Willgoss
Ralph Willgoss

Reputation: 12183

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

Upvotes: 1

Related Questions