Topic
1 reply Latest Post - ‏2011-09-20T11:39:07Z by SystemAdmin
SystemAdmin
SystemAdmin
33 Posts
ACCEPTED ANSWER

Pinned topic Compare two database

‏2011-08-26T10:12:28Z |
Hello all,
I am new to Optim Database Administrator I want to know how to compare two database
and to the different between them.
As I read in the following links:

http://www-01.ibm.com/software/data/optim/database-administrator/features.html?S_CMP=wspace&S_CMP=wspace

Compare two databases to find out if anything is different or missing. This is especially helpful for problem determination.
BR
Updated on 2011-09-20T11:39:07Z at 2011-09-20T11:39:07Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    33 Posts
    ACCEPTED ANSWER

    Re: Compare two database

    ‏2011-09-20T11:39:07Z  in response to SystemAdmin
    Hi,

    Follow the below steps for comparing databases,

    1. In ODA/DS, select the data perspective.
    2. Go to the data source explorer.
    3. Expand the connection profiles.
    4. Select SAMPLE and MYDB(in my case). In your case, select your databases.
    5. Right click and select "Compare With".
    6. Select "Each other".
    7. The popup will open.
    8. Please click on OK button with the default settings.
    9. The compare window will open.

    Refer the screen shot in the attachment.

    Best Regards,
    RRB.