Discussion:
sync 2 server
(too old to reply)
iccsi
2012-09-19 22:24:09 UTC
Permalink
I would like to have my SQL server 2012 to sync a SQL server database.
I just wonder is it possible to sync 2 database on the different server?
If yes, please advise any information on the internet.

Your help and information is great appreciated,

iccsi
Erland Sommarskog
2012-09-20 21:26:23 UTC
Permalink
Post by iccsi
I would like to have my SQL server 2012 to sync a SQL server database.
I just wonder is it possible to sync 2 database on the different server?
If yes, please advise any information on the internet.
Yes, it is possible, and there are no lack of options:

* Replication.
* The Sync Framework.
* Rolling your own with Change Tracking.
* SSIS.
* Log Shipping.
* Backup/Restore.

Which option is the best for you depends on your requirements, how big
the database is etc.
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
iccsi
2012-09-21 21:41:41 UTC
Permalink
Thanks for the message and helping,

iccsi
Post by Erland Sommarskog
Post by iccsi
I would like to have my SQL server 2012 to sync a SQL server database.
I just wonder is it possible to sync 2 database on the different server?
If yes, please advise any information on the internet.
* Replication.
* The Sync Framework.
* Rolling your own with Change Tracking.
* SSIS.
* Log Shipping.
* Backup/Restore.
Which option is the best for you depends on your requirements, how big
the database is etc.
--
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Continue reading on narkive:
Loading...