SQL 2000 - Best way to synchronise database across ftp only DMZ  
Author Message
breeze76





PostPosted: Tue Apr 10 21:36:08 CDT 2007 Top

SQL Server >> SQL 2000 - Best way to synchronise database across ftp only DMZ

Hi,

We have a need to synchronise data from a number of (Active) SQL Server 2000
databases within a corporate network to 'copies' in our DMZ.

Whilst log shipping was originally thought to be the answer I have been
informed the DMZ DBs would have to be non-operational which isn't really an
option.

The alternative appears to be to use DTS to output the transactional log
periodically. Then FTP it to them to DMZ and restore using another DTS.

I'm happy doing this but wondered if there were any more elegant solution(s).

Thoughts much appreciated.

SQL Server286  
 
 
Greg





PostPosted: Tue Apr 10 21:36:08 CDT 2007 Top

SQL Server >> SQL 2000 - Best way to synchronise database across ftp only DMZ

> Hi,
>
> We have a need to synchronise data from a number of (Active) SQL Server
> 2000
> databases within a corporate network to 'copies' in our DMZ.
>
> Whilst log shipping was originally thought to be the answer I have been
> informed the DMZ DBs would have to be non-operational which isn't really
> an
> option.
>
> The alternative appears to be to use DTS to output the transactional log
> periodically. Then FTP it to them to DMZ and restore using another DTS.
>
> I'm happy doing this but wondered if there were any more elegant
> solution(s).
>
> Thoughts much appreciated.


 
 
Greg





PostPosted: Tue Apr 10 21:37:13 CDT 2007 Top

SQL Server >> SQL 2000 - Best way to synchronise database across ftp only DMZ

> Hi,
>
> We have a need to synchronise data from a number of (Active) SQL Server
> 2000
> databases within a corporate network to 'copies' in our DMZ.
>
> Whilst log shipping was originally thought to be the answer I have been
> informed the DMZ DBs would have to be non-operational which isn't really
> an
> option.
>

Not sure what you mean here.

> The alternative appears to be to use DTS to output the transactional log
> periodically. Then FTP it to them to DMZ and restore using another DTS.

Umm, in other words... log-shipping.


>
> I'm happy doing this but wondered if there were any more elegant
> solution(s).

Replication?

What's the requirement on the ones in the DMZ, do they have to be
read/write, read-only, or what.

How far out of synch from the corporate network copies can they be?


>
> Thoughts much appreciated.



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html


 
 
GazJ





PostPosted: Wed Apr 11 02:10:00 CDT 2007 Top

SQL Server >> SQL 2000 - Best way to synchronise database across ftp only DMZ Hi,

To answer your queries:
1. The DMZ DBs can be somewhat out of sync with the corporte copies (upto
hours, even daily).
2. They must be read-able at a minimum (one of three may require to be
writable as well)
3. Not sure if replication is an option due to the FTP-only firewall.

Regards
Gary