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:
CREATE INDEX INTR.IININSTBO2_IDX ON INTR.TBININSTBO () ;
I have attached the entire generated scipt.
I'm using Release 184.108.40.206 and the software is up-to-date updated.
Can anyone help?
This topic has been locked.
1 reply Latest Post - 2011-04-08T16:05:21Z by SystemAdmin
Pinned topic Compare schema in 2 databases
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-04-08T16:05:21Z at 2011-04-08T16:05:21Z by SystemAdmin
SystemAdmin 110000D4XK33 PostsACCEPTED ANSWER
Re: Compare schema in 2 databases2011-04-08T16:05:21Z in response to SystemAdminThe 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.