We have 2 offices that we would look to keep our databases in sync with. Unfortunately one of our officers has a really poor connection and doing live SQL replication of the data probably isn't ideal.
The ideal situation would be live schema replication with nightly data replication.
If the ideal isn't possible strictly schema replication would be great.