Discussion Locked

connect to a remote db thru phone line

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

how do i maintain to databases perfectly
synchronized.
is it better to used snapshot or there is any other means for it .

3 replies

by mtnsqs

What databases are they?

Sybase will allow this via thier replication setup.

SQL can also replicate Db's - but its not as easy to set up.

How up to date do your want the db's? Are both being indepentanly accessed and updated? If the second one is only a reference Db used fro reporting etc, then maybe overrnight backup/restore is the solution. The method you use all depends on the level of updates you need and what actual Db it is.

by dsr28

This depends on how the data is used. If you are creating a scheduling application or resource management, you can't really function at run-time as two databases need to be queried all the time to see if a resource is still available. No amount of syncronization will keep it up-to-date, as you need the congruent answers from both to make a decision.

If your data is more of a lookup system that doesn't need locking in the manner I spoke of above, you can export the data and import it on another database over a phone line and send a snapshot.

This discussion is closed to new replies.