I have Merge Replication set up at our company with a central SQL 2005 as the Publisher/Distributor and the clients are all SQL 2005 Express.
In our remote branches we are having difficulty with the initial sync time. The database is ~2GB and is taking well over an hour for that first run. In troubleshooting this I noticed that I can specify an alternate Snapshot location and then optionally compress that.
I tried this(compressing) and it compresses it significantly but I am wondering what I should be aware of when turning this on. I notice it is a single .cab file in compressed form versus all the individual script files of before.
What are the catches?
Why wouldn't you always use the compressed format?
If both are left checked, default and alternate compressed, how do I tell it to use one or the other?