How to do Schema comparison in HANA. v

[Former Member]

Hello all, I have a requirement with one customer to do a schema comparison on DEV and TEST environments and get differential script for the tables modified in dev. I have used tools in that past like RedGate to acheive the same from SQL server. Any idea how we can do this schema comparison between two different schemas sitting in two different instances. Any inputs will be highly appreciated.

-Thanks,

Vinod Nair

vinod.nair@cognilytics.com

[Former Member]

Hi Vinod,

If you don't find any more automatic tool for that, I suggest to compare system views:

"SYS"."TABLES"

"SYS"."TABLE_COLUMNS"

Both views contain column SCHEMA_NAME, on which you can do filtering.

You will have to write an SQL to find differences (maybe operations on sets of data could be used).

Do let us know how you get to the results, you are expecting.

Hope that helps,

Leszek

[Former Member]

Thanks for the reply Leszek. I am going that direction too. if i see a diffrence in the table columns then generate the schema and write it somewhere. Do you know a way to dynamically get the ddl of the table? 

[Former Member]

As for now, I know only one way to get the ddl. I use Export of tables without data.

"Describe" command does not work in HANA.