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.
| Author |
Topic |
|
d0153030
Starting Member
8 Posts |
 Posted - 2004-10-25 : 04:36:31
|
| 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 anotehr 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 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2004-10-25 : 06:49:45
|
| I wonder if you should look into Replication. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-10-25 : 08:22:33
|
our admin is using replication for this... but it gets sent to germany (500 km)... it works...Go with the flow & have fun! Else fight the flow  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-26 : 08:36:24
|
| [x] Replication[ ] Other solutionKristen |
|
|
|
|
|
|
Office at different location - database How To?