Ora2pg可以用来将Oracle数据库转换成PostgreSQL,主要功能:
-Exportfulldatabaseschema(tables,views,sequences,indexes),withunique,primary,foreignkeyandcheckconstraints.-Exportgrants/privilegesforusersandgroups.-Exportatableselection(byspecifyingthetablenames).-ExportOracleschematoaPostgreSQL7.3+schema.-Exportpredefinedfunctions,triggers,procedures,packagesandpackagebodies.-ExportrangeandlistOraclepartition.-ExportfulldatasorfollowingaWHEREclause.-FullsupportofOracleBLOBobjectasPGBYTEA.-ExportOracleviewsasPGtables.-ExportOracleuserdefinedtypes.-ProvidebasichelpforconvertingPLSQLcodetoPLPGSQL(stillneedsmanualwork).-Worksonanyplateform.
评论