I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn. The vpn is permanent between the 2 sites and there are only a few tables that need replicated. Can anyone give me any advantages/disadvantages of replication over vpn or any issues with replication between SQL 2005 and Sql 2000.
Thanks
Well,
I think as long as the amount of data is not that much and speed is not a k.o. criteria, this will work from the networking point of view. I have several applications communicating via VPN which basically works smoothly, but of course latency is notably higher compared to nonVPN communication.
HTH
How do I consolidate multiple publications into 1 consolidated table on the subscriber? For example. Consider a very simple sales model where we replicate sales data from the stores to the central ...
I m trying to determine if there s a better way to handle replication than the way we re currently doing things. We re essentially trying to determine 2 things: Is there any way to add an ...
I am developing a web portal in Asp.Net. Primary target users will be of India Only. But in future I may target overseas users also. I want to know if I should use Sql Server Replication or not. ...
I have a few columns in a table that are added to my publication articles. When a change on a column that is not included in replication occurs, it still seems to update the msrepl_tran_version which ...
I am just getting started breaking a .NET application and its SQL Server database into two systems - an intranet and a public website. The various database tables will need to be synchronised between ...
I have a scenario where I m using transactional replication to replicate multiple SQL Server 2005 databases (same instance) into a single remote database (different instance on a separate physical ...
I keep getting the The merge process was unable to create a new generation at the Subscriber . Troubleshoot by restarting the synchronization with verbose history logging and specify an output file ...
We want to replicate data from one database to several others (on another server). Would it make sense to replicate these tables to a shared database on the other server and have our cross-database ...
