Postgres SQL is support in Hana Database ?

[Former Member]

Hi Expert,

I have existing PostgreSQL DB now our requirement to move the database to Hana ,

So can we directly used the PostgreSQL Script in Hana to create the same structure of database ?

Thanks,

Sumit

[kapil_tilwani]

Hi Sumit,

Yes, you can. SAP HANA is ANSI-SQL compliant - same as PostgreSQL. But it all boils down to how much of the base ANSI-SQL you have really used.

PostgreSQL has extended functionalities to use it is as on ORDBMS, Procedure polymorphism, etc., which are different in SAP HANA. Some examples of small but important differences exist like there is no varchar(max), varchar is not unicode, procedures do not have polymorphism.

But, if you have been using PostgreSQL largely as a data-store, it should be a smooth migration. But beware, once you have migrated to SAP HANA though, the performance is quite addictive. 🙂

Regards,

Kapil