I've developed a website with Drupal 7 running on standard PHP/MySQL server. Now there's a need to move it to server with Oracle database. I managed to set up testing environment with a fresh Drupal 7 install and all my modules to check if they are working with Oracle DB. Now all data from original development version needs to be moved to new server. First option was to use Oracle SQL Developer "Migrate" function, but I ended up manually copying tables from repository to Oracle DB and in the end it failed to function. Next thing I tried some Drupal migration modules, but it didn't turn out well, because not all data was migrated. Does anyone had successfully achieved the task of moving data from MySQL to Oracle database? Preferably using open and free software, but commercial products are an alternative, if they work fast and efficiently.
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|