• 1 reply
  • Latest Post - ‏2011-04-08T16:05:21Z by SystemAdmin
33 Posts

Pinned topic Compare schema in 2 databases

‏2011-02-01T13:28:07Z |
As a new user to Optim Database Administrator I have tried to compare a schema in a test and a production database. But it really isn't obvius in the product where the differences are between the two schemas and tt seems like the comparison find differences where aren't any!

When generating the change management script I get lots af wrong DDL like this:


I have attached the entire generated scipt.

I'm using Release and the software is up-to-date updated.

Can anyone help?
Updated on 2011-04-08T16:05:21Z at 2011-04-08T16:05:21Z by SystemAdmin
  • SystemAdmin
    33 Posts

    Re: Compare schema in 2 databases

    The compare editor might show a lot of objects as having differences due to changes in certain properties like
    names of primar keys, unique constaints etc. causing you to see more objects that what you are expecting.

    Regarding the Create Index statement generated, it looks like you have not added the column for the index after adding the object to the Change Management script editor. It could be somethig else but it would be nice to verify this on a smaller set of objects.