If we follow your suggestion, what we need is:

1. We get from source at the begging a full backup and restore it destination.

2. Everyday we get the daily log file...

I am not sure I understand the idea behind. Robocopy is a copy tool. The point is how to use log shipping to SQL express versions.

Log shipping is not available to SQL express editions

Dear Santoni,

I definitely agree with you. We do not want to write a code to sync both databases. That's why are trying to find a ready tool. The vessels (customers...

They send it via email

The problem is, we don't have internet connection to publisher !. The installation is "isolated" on a Vessel ! We can only exchange files.

You said "Merge Replication is designed for subscribers staying offline for long periods". YES, ok. When it comes online, as I understand, must be able to connect to the publisher,...

Thanks a lot for given info. We try it and let you know !

Dear Santoni,

for our case, the problem is we don't have a continuous connection between subscriber and publisher. Can we accomplish this offline ? Also, our source db is on SQL...

I am not aware of this. Can you please give me some details regarding "merge replication" ?

Thanks a lot for your time and your suggestion. We do need data during voyage. We will set up a test environment with your suggestion and I will come back...

Good question...

Because, the db is installed to an 'isolated machine' - without any access to the outside word. So, we take scripts from one machine, we copy them to other...

What I plan to do is:

1. We install the db to customer with some initial data (db 1 )

2. We install the some db (as above) to...

One idea we have is to export data to a script file and then send file via email to build remote db. What do you think ?

What we need is to replicate the data base somewhere outside of the customer db and server. The customer db is on vessels, so we do not have Internet connection,...