File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Replication of data in SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Replication of data in SQL Server" Watch "Replication of data in SQL Server" New topic

Replication of data in SQL Server

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Reqt. is to replicate data in two DB servers(using Publication & Subscription in SQL Server2000) as data is synchronized , initially I fetch data from First DB server, if its down I go for Secong DB server and fetch the data and vice versa as this procedure continues throughout my application and so need to ping everytime I open a connection to DB server and check whether its running.
So, is there any other alternative to test whether connection object is alive to proceed to other server.

SCJP 1.5, SCEA, ICED (287,484,486)
I agree. Here's the link:
subject: Replication of data in SQL Server
It's not a secret anymore!