Topic
  • 1 reply
  • Latest Post - ‏2012-07-09T21:14:56Z by SystemAdmin
JF9Y_Mathew_Patterson
1 Post

Pinned topic Can I restore a DB2 9 database to a DB2 Express database?

‏2012-06-25T16:28:09Z |
At my work, we use an application with a DB2 9.7 FixPack 4 database backend. There is some poking around I'd like to do with the data, however, not being an experienced database user, I feel uncomfortable with accessing the database directly. The database does create a nightly backup though.

I was wondering if there's any way of taking that nightly backup and restoring it to a separate server, running DB2 Express-C. I really only need access to the tables, I don't care about the procedures or views or anything else, I just want to be able to run some queries against the tables in the database.

Any help would be appreciated!
Updated on 2012-07-09T21:14:56Z at 2012-07-09T21:14:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Can I restore a DB2 9 database to a DB2 Express database?

    ‏2012-07-09T21:14:56Z  
    Hello,

    I have never tried, but I would believe it is possible, as long as your backup was not taken from a DPF database.

    The best thing to do is to try :-).

    Regards
    Yves-Antoine Emmanuelli