About Distributed System

[phrajib]

I have a distributed system in VB that is running in one office.Now they are wanting to run the same software in another branch. But they want to transfer datas from one offices database to another everyday by floopy/cd/email.

How I can do that in VB and sql server.

---Rajib

[Hack]

If both offices are on the same network, or can access the same network, on which the SQL Server resides, they can to updates in real time.

If not, then perhaps the branch that needs to be uploaded can just do a backup and FTP the backup file to your site.

[phrajib]

Actually both the offices make transactions and they are not in the same network.
Both the databases updated every day. At the day end I need to update both the databases by a process.

Can anyone help then?

--Rajib

[Hack]

Actually both the offices make transactions and they are not in the same network.
Both the databases updated every day. At the day end I need to update both the databases by a process.

Can anyone help then?

--Rajib

So, you are talking about an automated process?

Unless an electronic connection between the two can be made then manual intervention is unavoidable. If the databases are not on the same network someone on one end will have to manally download the days transactions to some type of media, and ship that download off. Someone on the other end will have to receive that download, and kick off an upload.