Database Synchronization
-
Hi guys, I need to update the data in local database from other database automatically, by date or suggest if there is other way thanks for the help :)
-
Hi guys, I need to update the data in local database from other database automatically, by date or suggest if there is other way thanks for the help :)
Depends, on the connection, databases used, and your data. Running a script on a timer is the obvious way, but you might want to take a look into materialized views, or indexed views depending on your flavour of RDBMS. I don't necessarily recommend it, it depends.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Depends, on the connection, databases used, and your data. Running a script on a timer is the obvious way, but you might want to take a look into materialized views, or indexed views depending on your flavour of RDBMS. I don't necessarily recommend it, it depends.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
Hi, Im using 2 oracle databases how this could be possibly done?
-
Hi guys, I need to update the data in local database from other database automatically, by date or suggest if there is other way thanks for the help :)
-
One option would be to use the Sync Framework[^].
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
Hi, can I use stored procedure to sync data from other database using DBLink? What are the possible querries that I need to do in this process?
-
Hi, can I use stored procedure to sync data from other database using DBLink? What are the possible querries that I need to do in this process?
KingJames06 wrote:
Hi, can I use stored procedure to sync data from other database using DBLink?
Dunno, I don't know DBLink. Hence, I can also not say if it is an easier or more efficient approach than the Sync Framework which I did recommend.
KingJames06 wrote:
What are the possible querries that I need to do in this process?
Depends on your database and it's structure. Syncing is a delicate process, I suggest you take a few days to read everything on the topic that you can find :)
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
Hi, Im using 2 oracle databases how this could be possibly done?
Start with creating a database link. Here's[^] the reference. But as the Oracle reference sucks for learning, I suggest that you google it instead. There's a ton of info on the net. When you have created the link you should be able to
SELECT * FROM mytable@the_other_server. If this works you can either run a script to update the tables on your server, or create a materialized view that does this automatically. How to create a materialized view is a much to big subject to answer here, I suggest google again. Just remember that there are a lot of conditions that needs to be met to get a MV to work.Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Hi, Im using 2 oracle databases how this could be possibly done?
More info on Advanced Replication[^] It always helps having the right search term. You can also find Advanced Replication setup in the Oracle Enterprise Manager under the Data Movement tab.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
Hi guys, I need to update the data in local database from other database automatically, by date or suggest if there is other way thanks for the help :)