SQL Server 2005 data replication
Posted on 2007-12-04
We currently have data on SQL server 2000 in our office server.
We need to replicate data from the SQL server in our office(CA) to the disaster recovery server(TX) at a remote location on a daily basis.
We are looking at a product caled "WanSync" to serve this purpose, but it is expensive.
Is there functionality in SQL Server 2005 that has features for data replication from one server to a remote server? In that case we wont have to buy "WanSync" & can upgrade from SQL Server 2000 to SQL Server 2005.