CODEWITHSUNDEEP
ms-accessoracle11goracle-sqldeveloperdatabase-migration
Martin Andersen
Martin Andersen

Reputation: 2730

Import MS Access schema to Oracle

I found this guide using Oracle Sql Developer to import MS Access XML schema files to Oracle. But there have been a lot of changes in Sql Developer since the guide was written.

Does anyone know if it's still possible to migrate MS Access to Oracle using latest Sql Developer tools?

Upvotes: 0

Views: 88

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22427

No, we no longer support Access 'migrations' to Oracle in the current code base.

Java deprecated the odbc-jdbc bridge, and we were relying on that for Access connections.

You would need an old copy of SQL Developer (v3.1) to use this feature.

Now, if you have a SQL Server instance handy, you could move it over there, and then use SQL Developer to migrate the data to Oracle.

If it's a simple db, you could offload the tables to flat files (CSV), and use SQL Developer to create the tables from that.

Upvotes: 1

Related Questions