Smart ExportImport from 11g to 12c
SmartExportImport from 11g to 12c:
Today got a request from one of my friend to show how smart export import behaves if we do it between 11g and 12c. Remember any version of 11g object can be imported to 12c. To know what Oracle says refer this link.
Exported from: ODI 220.127.116.11
OS: Windows 8.1, Database: Release 18.104.22.168.0 Production
Exported to: ODI 22.214.171.124
OS: Windows 8.1, Database: 12c
To showcase this I had taken HR and SH schema. In the 11g interface I have used two dataset with operator as intersect, a join between employees and department table, a filter on department_id, a refresh variable two give some random characters and odi user function for lower case. You can see down below, smart export/import works flawlessly without any issues. Interface got transformed into mappings with proper components. Functions and variables are created as it was in 11g.
Note: During import to 12C, it will ask you to provide an upgrade key. Remember this key and use the same for subsequent import. To know in more details about upgrade key click on this link.
Objects in 11g:
This is how it looks like after importing into 12c.
Here is a comparison of each object:
Let me know if you face any issues while performing smart export/import.