SEO

Our company is trying to come up with a system to keep a SQL database replicated. Basically, we have a software application that is used at a remote site (our customer). the application used to use an access database. in order to view the data at our office, we would download the access .mdb file every morning. When done, we could open up the application on our end and see data that was somewhat up to date. the application has moved away from access (for obvious reasons) to sql/msde database. we obviously can't just download the sql database and then open up the application on our end to view the data. we are looking to do the following:

- backup the msde database every morning at 7:00 am
- use some method to automatically push the backup file to our company's server at 7:30 (ftp, email, or some other method)
- use some method to automatically restore the database on our server at 8:00

or

- copy the current MSDE database from the customer site to our site
- once a day at 7:00 the database will do a transaction log to capture all of the transactions in the last day
- the transaction log would get pushed to our server at 7:30
- use some method to import the transaction log into the database on our server at 8:00

either way....we want to just be able to open up the application on OUR END at 8:02 and see the entire database from our customer's end (as of 7:00 that morning).

Do you have any advise as to how this can be done? What program(s) should we use to backup/restore the database and which to somehow push the data over the internet (we do not have a VPN established......we just use gotomypc.com to connect to the customer). any help would be GREATLY appreciated.