My client is getting ready to move some of our tables from MS-Access 97 to Oracle 7.3. Does anyone have any suggestions for handling this migration? Does anyone have any experience with using Access as a front end for Oracle?
wrandall,<br>
<br>
I've been out for a while, but don't see any response here. I've used Access to manipulate Oracle data for several years. Learned early on that while Access is not particularly case-sensitive, Oracle was when it came to creating/naming tables (Oracle v7.1?). Mind, I've not done a great deal of Access to Oracle conversion, but what has been done went very well, the only hangups having been my proclivity to use memo fields in access when smaller text fields would have done just as well.<br>
<br>
Specifically, I was using Access v2.0, ODBC driver for Oracle was InterSolv (was Q+E then) and don't recall the version, probably 2.0 or 2.1. Could not transfer Access relationships or other constraints, but the data transfer was simple, albeit slow.<br>
<br>
There's an upsize wizard app for Access to move to SQL Server, but I'm told that it works equally well (?) moving data to Oracle 7.2 and above. Cannot attest to that directly, but previous experience suggests that there is probably 90% compliance or better for data transfer. You'll likely have to [re]build table relationships, data constraints, etc., but that shouldn't be overly difficult - just tedious.<br>
<br>
I worked with an Oracle 7.3 back end for 4 months recently and you don't talk directly thru ODBC. You have to go thru a layer called SQL Net. This introduces some challenges if you're used to dealing with data on SQL Server. For instance, we were linking to tables on Oracle and SQL Server and the tables on Oracle would appear to be read only when they weren't. It turned out that linking manually to the tables would produce a dialog requesting a unique index for the table. SQL Server doesn't do this, and you don't see it with Oracle from Access when you Link the tables using VB. The solution was to create pseudo indexes for the Oracle tables using the Create Index command. <br>
<br>
If you're used to file server data only this will be a big change.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.