Its been almost a week trying to solve this database migration. The source in msaccess, mysql, csv and text file and my target database is oracle.
Here are the following steps in my migration path:
1. Install oracle database server Oracle Database 11gR2 on CentOS 6.3 64 bit
2. Install Sqldeveloper on MacOSX 10.6.8 64bit plus third party database connection (jtds driver, mysql driver and access driver)
3. Oracle database repository preparation
4. Actual migration process using sqldeveloper migration tool.
5. Test and verify migration process.
Details of this process is not part of this post.
No comments:
Post a Comment