In Oracle ‘n’ is number of bytes whereas in PostgreSQL ‘n’ is number of characters Some of the important Data type conversion between Oracle and PostgreSQL is as follow. Please check below some of the important differences you should know before migrating. There is no any tool that can convert 100% Oracle database into PostgreSQL, some manual changes are required. Understand the differences between Oracle and PostgreSQL and convert it using any tool. It connects to the Oracle database, scan it automatically and extracts the data, generating the database migration report. Ora2pg tool is very helpful for migration assessment. Migration AssessmentĪfter preliminary check, the first step of migration is to analyze the application and database object, find out the incompatibilities between both the databases and estimate the time and cost required for migration. Do not waste time replicating data that you don’t need, for example backup data and temporary table from past maintenance. Also, check whether there is any historical data required or not. Do not waste time for migrating objects that are no longer required. It is important to understand which part is to migrate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |