• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to clone records of one table to another table in runtime?

 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
thank you for reading my post,
I have one database which is a part of another application which my application should work in relation to it.
a problem that i have is something like this:
DB1 which is the old (already working ) application database has some tables which my application need thier data.
but DB1 tables are always under changes, ( records are comming , updating, and going out of the table)
How can my application understand when a record is changed in old tables in order to react to those changes?

Thanks
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If both databases are on the same server, you could just use a trigger to keep them up to date.
 
raminaa niilian
Ranch Hand
Posts: 551
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
they are not in the same server and they are not the same databases .

Thanks
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So you are looking at some sort of database synchronization or replication tool. These sorts of things tend to be heavy-weight and expensive. Have a google for "database synchronization" to see what's out there.

How do you use the data in DB 1 and what database is it? Do you only need to read from tables? If so some databases allow you to create tables views that are actually tables in another schema, which might avoid the need to use any sort of synchronization.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic