We have some EMR software which uses mssql server as the backend and there are issue with speed over a WAN connection. So I have a thought of placing a server at this remote site and doing replication between the two sites. They need to pretty much mirror each other.
Does anyone have some guides on best practices for setting this up?
So my second reference above applies. Look also at Hilary Cotter's blog post on the subject here (http://sqlblog.com/blogs/hilary_cotter/archive/2011/10/28/implementing-bi-directional-transactional-replication.aspx)
Trying to figure out group policy inheritance and which settings apply where can be a chore. Here's a very simple summary I've written which might help. Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.