Is there any way to Compare Two Databse schemas

[philippoommen1]

Hi,

We are having situation as follows.

Last 1 year we are working with a new version of our product(950).It involves lot of DB changes over the LAST released version(940). During the Db changes End of the day, we prepare the Delta and apply on 940 DB.

End of the development , when we took the Delta DF with 940 Database and randomly cross checked with the previously applied Deltas(During Development) , we found some mismatches. Such as renaming of field, format changes etc....


We cannot take chances. There should not any difference in Schmas for 950 FRESH customers and 940 Upgrade customers because same r-code running against both the DB.

We need a full proof test to find any schema changes with 950 and the upgraded 940 Databases. Is there any way to do this programtically?

TIA
Philip

 

[rzr]

so, you have applied schema changes only on 940 development db.... and
your 950 development schema = existing 940 schema + new delta's applied to 940 over the last one year....

correct ?

you could create a new incremental df by comparing 940 dev and copy of 940 live - that should show you all new changes applied on 940 dev...

 

[MaximMonin]

you can use t_File and t_fields temp-tables to put contents of _File and _Fields system tables and then use compare with some tool.
Or just dump it to xml file and use file-compare. Remove some atributes before.

 

[tamhas]

What is it that the incremental .df tool does that is not enough?

If all of the existing customers have exactly the same schema and you have a copy of a data base with that schema, it should be a simple matter to create the incremental .df.

 

[AbhayShukla]

HI,

You should take care while dumping delta df.especially when it asks questions related to renaming,updating or dropping similar objects.

Thanks.