SQL Server database synchronization issues
Posted
by George2
on Stack Overflow
See other posts from Stack Overflow
or by George2
Published on 2010-04-27T03:55:20Z
Indexed on
2010/04/27
4:43 UTC
Read the original article
Hit count: 218
sql-server-2008
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
© Stack Overflow or respective owner