Hi all,

I'm trying to develop a Java application that will manipulate and
transfer data from sql server X to sql server Y. I'm pretty new to this
sort of thing, but how can my Java application be notified when a record is
updated/inserted into X so that it can be stored in Y? Does Java have some
kind of event-driven api for this sort of thing?

Many thank in advance,

Why use Java, when SQL Server has a built-in mechanism called Replication? I
think transactional replication is what you are after. Please check SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]
Hi all,

I'm trying to develop a Java application that will manipulate and
transfer data from sql server X to sql server Y. I'm pretty new to this
sort of thing, but how can my Java application be notified when a record is
updated/inserted into X so that it can be stored in Y? Does Java have some
kind of event-driven api for this sort of thing?

Many thank in advance,
Inder

Hi Narayana,


I'm replicating (after some major data testing and modifications)
records one way, from sql server X to sql server Y. Sql server Y is a
backend database for a application called Blackboard and they have
several Java api's to update and retrieve data from their database, and
they suggest that we don't use transactional replication but build a
standalone application. I'm not familiar with developing applications
in middle tier (or any tier) and just wanted to know if an application
in Java CAN be build to do this sort of thing (and how).

Thanks again,
Inder