Associate
- Joined
- 3 Oct 2004
- Posts
- 68
- Location
- Biggin Hill
What is the best way of moving data from one database to another, the database I will be using is Oracle.
I basically will give the user the option of database 1 to database 2, I will then list the possible tables to move, once the user has decided what tables to move the data will then be moved from the source to the target.
I was thinking of using a database link to accomplish this, but wondered whether anyone had a better way of acheiving this.
p.s. this doesn't have to be done in PHP, I could use PERL/CGI
I basically will give the user the option of database 1 to database 2, I will then list the possible tables to move, once the user has decided what tables to move the data will then be moved from the source to the target.
I was thinking of using a database link to accomplish this, but wondered whether anyone had a better way of acheiving this.
p.s. this doesn't have to be done in PHP, I could use PERL/CGI