Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
converting access to oracle
- Thread starter softjack
- Start date
I have been through this process and it helps if you were already using ADO to communicatre with the Access database.
The biggest thing is that the SQL query / scripts are different in Oracle to Access - so I took the data tier of my application and went through it manually changing all of the Access SQL to the appropriate Oracle SQL. Pay particular attention to date fields, as you ned to use the to_date function in Oracle SQL.
I am sure somebody out there has a much better mechanism, but it was not too much of a pain.
HTH.
The biggest thing is that the SQL query / scripts are different in Oracle to Access - so I took the data tier of my application and went through it manually changing all of the Access SQL to the appropriate Oracle SQL. Pay particular attention to date fields, as you ned to use the to_date function in Oracle SQL.
I am sure somebody out there has a much better mechanism, but it was not too much of a pain.
HTH.
You wouldn't use VB to convert a database from Access to Oracle. I believe Oracle has a conversion tool that allows you to migrate your database objects (tables, queries) to Oracle via a wizard.
Oracle doesn't use the same data types as Access and the Oracle SQL dialect (PLSQL) is quite different from the syntax you'd use with Access.
As far as your front-end app, you would need to change your connection string and most of the data sources of your recordsets should be stored procedures instead of queries. With ADO as your data access method, this is pretty straight forward.
The wisest people are those who are smart enough to realize they don't know it all.
Oracle doesn't use the same data types as Access and the Oracle SQL dialect (PLSQL) is quite different from the syntax you'd use with Access.
As far as your front-end app, you would need to change your connection string and most of the data sources of your recordsets should be stored procedures instead of queries. With ADO as your data access method, this is pretty straight forward.
The wisest people are those who are smart enough to realize they don't know it all.
I found a link here to give you a few ideas. I'm in no way endorsing this product but gives you an idea of what is out there. This will supposedly convert your databases to Oracle, change the datatypes, etc.
Obviously you want to make a backup copy of your Access DB BEFORE you perform any conversion.
The wisest people are those who are smart enough to realize they don't know it all.
Obviously you want to make a backup copy of your Access DB BEFORE you perform any conversion.
The wisest people are those who are smart enough to realize they don't know it all.
- Status
Similar threads
- Locked
- Question
