This content has been marked as final. Show 4 replies
You're in luck - SQL Developer is our official migration tool.
Read the docs and let us know about any specific questions you may have
Note you'll be migrating the tables and data, not necessarily the forms/reports/application bit of the Access database you're working with.
Thanks for the reply. I want to migrate not only the tables.. want to migrate each and everything which are available in MS-Access. So please guide me now as per my requirement.
Thanks for your help.
Now I am able to migrate data from MSAccess to Oracle DB. We are migrating the data Manually here.
Is there any automation script to do the migrating the data from MSAccess to Oracle Database?
Please let me know if we have any.
If you right-click on your Access connection, you can choose 'Copy to Oracle' and that will bring all of your tables and their data over.1 person found this helpful