how to create sql for constraints when migrating from oracle
Posted: Mon Oct 19, 2015 7:52 pm
We are migrating from Oracle to Vertica. We have all of the tables created. Is there an easy way to generate generic/vertica compatible DDL/sql alter commands to add the constraints to the new Vertica DB? Maybe from the all_constraints data. Could oracle dbms_metadata.get_ddl be used to generate commands that we can run directly? I thought maybe someone had tackled this before. If there are tools that may be used that would be helpful as well.
Additionally, if there is an easier way to get the schema info from oracle (including these constraints) to do this at once and have the commands be compatible with Vertica, please let me know.
Thank you in advance.
Additionally, if there is an easier way to get the schema info from oracle (including these constraints) to do this at once and have the commands be compatible with Vertica, please let me know.
Thank you in advance.