Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Copy Database structure from Oracle 10g to Access 2007

I want to copy Full Database from Oracle 10g to Access 2007.

That meaning copy Tables, Relationship between tables

Can any body help me
0
interbus
Asked:
interbus
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
could you please clarify why you want to do that?
also, what size is that oracle database?
0
 
HoggZillaCommented:
I will tell you how I would do it, using SQL Server Integration Services. SSIS.
Copy the Oracle db to SQL Server first, then to Access. Or I might try to go directly from Oracle to Access directly. But probably not.
0
 
kuknoCommented:
Hi,

you can import data directly via ODBC from other databases to MS Access. See here for a simple example:

http://www.pervasive.com/library/docs/psql/910/usrguide/usrguide-03-6.html#wp92146

All you need is to setup an ODBC connection to your Oracle database. See the oracle docs for this, or ask the Oracle DBA to help you.

Regards
Kurt
0
 
interbusAuthor Commented:
Good answer kukno

I know this way to import data directly

but I need to pring all tables with relationship identification on oracle

this way only import tables without relations

kukno you near to get 500 points but give me what I want
0
 
ee_autoCommented:
Question PAQ'd, 500 points refunded, and stored in the solution database.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now