DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Documenting backing up of data from oracle to access.

  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Documenting backing up of data from oracle to access.

    This may not be the place to ask however i am looking for resources on how i may document data I am backing up from an oracle database to MS Access.

    Basically I have my oracle database and i have an Acess database.

    I have to back up 3 tables from oracle into access.

    I have no idea how i would document this.

    I want to say Columns 1, column 2 from table A in oracle will be backed up to Column 1a and Column 1b in Access.

    Maybe i need to visit a visio forum?

    Has anyone had similar exeperiences

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That's a new one, backing up Oracle with MS Access. Just when you think you've heard it all....

    Why not just back Oracle->Column1 to Access->Column1?
    Jeff Hunter

  3. #3
    Join Date
    Dec 2000
    Posts
    138
    I dont know if this may help, my 2c
    Open the table in access as a link and then save it as a mdb file.

    -dharma

  4. #4
    Join Date
    Mar 2004
    Posts
    55
    I probably as usual did not exaplin myself well.

    The reason the oracle data is being backed up to oracle is because there is a backup piece of software for the frontline software that uses the oracle db.

    This simplistic backup piece of software uses access.

    So when our frontline app goes down we then use the simplistic version which sits on top of access. (Its legacy software)

    I am only grabbing a few columns from oracle and i will probably get it dumped to a csv file and then load it into access.

    My aim is however to come up with a document that shows what bits of data from my oracle db will be backed up to access tables so that its obvious to the average jow blow exactly whats going where. I am looking for an example or a standard.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width