How to keep SQL-DMZ and SQL-Internal in sync ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marlon Brown - 27 Jun 2005 01:35 GMT

If I decide to place a SQL db in the DMZ so that the SQL-db-DMZ can retrieve
info from the SQL-db-internal-SAN, what would be best way to sync such
database from SQL-db-internal-SAN to the SQL-db-DMZ ?
I mean in the past I used robocopy tools to help me keep folders in sync
from DMZ-servers to DMZ-staging servers, but I would like to find out what
would be the best tool to accomplish this in SQL ?

Reply to this Message

Mike Epprecht \(SQL MVP\) - 27 Jun 2005 09:29 GMT

SQL Server Replication is an option.

What latency can you have?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> If I decide to place a SQL db in the DMZ so that the SQL-db-DMZ can
> retrieve info from the SQL-db-internal-SAN, what would be best way to sync
> such database from SQL-db-internal-SAN to the SQL-db-DMZ ?
> I mean in the past I used robocopy tools to help me keep folders in sync
> from DMZ-servers to DMZ-staging servers, but I would like to find out what
> would be the best tool to accomplish this in SQL ?

Reply to this Message

Marlon Brown - 28 Jun 2005 15:26 GMT

It is a standard web site for my organization. No big urgency to get data
replicated.
Let's say latency <= 1 hour. Is that OK ?

> SQL Server Replication is an option.
>
[quoted text clipped - 17 lines]
>> from DMZ-servers to DMZ-staging servers, but I would like to find out
>> what would be the best tool to accomplish this in SQL ?

Reply to this Message

Kevin Madsen - 29 Jun 2005 15:21 GMT

Replication should handle that without much issue.

Kevin Madsen
kevin.madsen@gmail.com

Reply to this Message