Replication Question.

[rob56]

I am a new DBA and we want to replicate a large (approx 20 gigs) database, from our internal network to our external network. The subscriber database will be read only and will only need to be updated once a week. The published database will have a considerable amount of change between replications.
How should I approach replication? If I do snapshots, that means every time the publisher publishes the snapshot it will have to make a snapshot of the whole database and all that data will have to be transported through our firewall. What are the best options I should look into to minimize the replication process and network traffic?
Which replication model: snapshot, transactional, etc should I consider, or not consider.
Any information is greatly appriciated!
Thanks
Rob

[MAK]

I recommend you to do a backup,zip,FTP and restore it the destination server cas' you need it only once a week.

if you like use SQLZIP that will do the compression by itself.

[rob56]

I have never heard of SQLZIP, does it come with SQL?
Also how could I automate these steps?

By the way, I am using SQL Server 2000.

[MAK]

How fast you need.

My article related to your question is on its way. you will see it in here soon
(in a week)

[MAK]

BTW SQLZip is a third party compression software.

www.sqlzip.com