How the compatibility score is calculated
Migration compatibility (expressed in terms of %) helps to find out how easy to move a given table from one source database type to target database type.
Take the example of ‘Wide table containing simple and complex data type’ and compatibility has to be calculated between Oracle source and Postgres target database.
Here are the characteristics of the table:
Table containing 50 columns
30 columns of simple data types, 10 columns of date, 10 columns of XML
Table containing three columns being a primary key columns
Total number of total rows - 1,000
Total size of the table is 1000 MB
Again, analysing each factor of the table and its compatibility with the source and target database and adjusting the score based on the supported factors will help us to find out the migration compatibility.
Factors | Value | Target Postgres compatibility | Oracle Score | Target Score |
Column count | 50 | Postgres supports table with 50 columns | 200 | 200 |
Size | 1 GB | Postgres supports table of 1 GB size | 1000 | 1000 |
Row Count | 1000 | Postgres supports table with 1000 rows | 200 | 200 |
Primary key Column | 3 | Postgres supports table with PK | 30 | 30 |
Data types | 30 | Postgres supports all simple data types | 30 | 30 |
Data types - Date | 10 | Postgres supports Date datatype | 30 | 30 |
Data types - XML | 10 | Postgres does not supports XML datatype | 200 | - |
Total | 1690 | 1490 |
Total migration compatibility (computed as % of Target score/Source score) = 1490/1690 = 88.1%