Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Database data transfer from one location - another

Author  Topic 

d0153030
Starting Member

8 Posts

Posted - 2004-10-25 : 08:21:07
Hello

Wel I can understand that the Subject might be confusing.
Well the problem scenario is like this:

There are two offices of an organisation situated at distance say 7-8 Km apart. I have to develop and point of sales application for this organisation.

Both application will run at their respective client sites. Well following are requirements:

1.0 Each office need to send each day records to another office location, Say Office A and Office B are there. Than Office A and also Office B need to send the day to day transaction to the Office B and Office A respectively.

2.0 This would work as backup of the data as well as availability of records of both office at one location.


What I am planning is that in evening each office will connect there system with internet?

My software must need to make copy of each day transaction to a backup fil or anyother thing?

This file will then be sent to the another office through internet.

When both office recieves backup file from other office then they will provide this file to application and application must read data out from backup file and must store it to the main database with them.


HOW TO DO THIS?
ANY suggestion about the schema thought or how to achieve this?


Leave Your Marke Wherever You Go

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-10-25 : 08:24:34
please don't cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41670

Go with the flow & have fun! Else fight the flow
Go to Top of Page

d0153030
Starting Member

8 Posts

Posted - 2004-10-26 : 05:27:32
Dear spirit1

This post was based on your suggestion, that this post belongs to this group.

Well Does any body have any idea for this? How to get the solution for this?


Leave Your Marke Wherever You Go
Go to Top of Page
   

- Advertisement -