How to copy newly inserted records from local database to different database

user_10839565 0
Viewed 47

We have a new development database setup on some server for our application. Currently we have a local database that we made use for testing our applications. Now we would like to move the newly inserted records in our local db to remote dev db.

Every colleague has their own set of records locally, so each one of us should be able to move their records. Planning to have a script that would help achieve this.

I know about "Insert into Select" but do not know how to use when source and target databases are different. Also how to consider dependent tables while doing the insert?

insert oracle sql
2 Answers

There is not just one single answer to your question. You can perform this 'ETL' process manually or one can create an automated process to achieve the desired results.

Database Link

Oracle allows you to create what is called a database link. Take a look and see if this could be a path to achieve what you are looking to do.

Export Import via Excel

Otherwise a really manual approach is to export your data into an excel file... and then reimport the data into your other database. If this is needed once or just a few times this approach is really quite simple.

You can import the excel file into it's own table and then after the data is in the desired database you can then write simple selects to INSERT the data where it needs to go.

The above are just two ideas... but the solution can become extremely complex depending on the 'system' that is required to perform the ETL operation.

user_60263850

Did you try oracle replication , Oracle snapshot.. These things will help thanks Also there are data guard solutions I have not tried oracle streaming ..Oracle streaming too could work

user_83783930
Related