This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Replication of data in SQL Server" Watch "Replication of data in SQL Server" New topic
Author

Replication of data in SQL Server

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Hi,
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.
Thanks,
Anil


SCJP 1.5, SCEA, ICED (287,484,486)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Replication of data in SQL Server