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

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:

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

    Re: Compare two database


    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,