Below are instructions for filling out the Spreadsheet for converting your custom tables/views/objects to Postgres: Instructions are provided for each spreadsheet in the folder for your program. Some don't need any action and some do require actions. 

• You do not need to delete any tables/views that you do not intend to migrate. Just put a "N" in the column.
• Please make sure that there are no blanks in the "Migrate" columns for those sheets that need action. There should either be a Y or N for every row.
• We will send you another set of spreadsheets prior to your conversion that will capture any changes that you have made since this export. You should be able to copy/paste most of your values except for any new rows that are added.

Spreadsheets

• Custom Date Columns:  This is a list of your custom date columns in your Biotics 5 database that will be converted. This is for your information only. No action is needed.
• Custom Foreign Keys: This is a list of your extensible tables and their relationships to other tables. This is for your information only. No action is needed.
• Custom Functions: This is a list of custom functions in your database. Action Needed: Please indicate in the Migrate column a "Y" for migrate or "N" do not migrate. Please make sure every row has either Y or N. 
• Custom Numeric Columns: Certain numeric datatypes are changing during the migration process. This spreadsheet provides you with insight if there could be errors in your database that could cause issues during migration. Please look at the "Decimal Values Found" column for any rows with "Y" and investigate further and update any records that need to be updated. Although no action is required in this spreadsheet, you should make any updates to the data prior to conversion.
• Custom Procedures: This is a list of custom procedures in your database. Action Needed: Please indicate in the Migrate column a "Y" for migrate or "N" do not migrate. Please make sure every row has either Y or N. 
• Custom Tables: This is a list of custom tables in your database. Action Needed: Please indicate in the Migrate column a "Y" for migrate or "N" do not migrate. Please make sure every row has either Y or N. The other columns in this sheet are for your information. The only column needing action is the "Migrate" column.
• Custom Views: This is a list of all of the custom views in your database. Action Needed: The first thing you should do is take a look and see if there are views in here you do not plan to migrate and mark those with "N". Then look at the remaining views. If there are views with Valid = "N" then you will need to look at that view and determine why it is not valid and fix it prior to migration. If it fails, it will not be migrated. If you are not migrating it, no need to fix it. Similarly, if the "Contains Problematic Outer Join" column contains a "Y", then you need to fix that outer join prior to conversion. There are Help Desk Solutions that can help fix these. After conversion there may need further refinement needed to get them to properly work in PostGres but they need to be valid in Oracle prior to conversion.
  
  
  • Oracle → PostgreSQL Migration Issues For Queries and Views
  • Copy/Paste Prompt — Oracle → PostgreSQL Conversion Assistant