Hi community,
I have two Innovator instances. Both have different purposes and unique applications.
I want to transfer one of the custom applications (incl. ItemType, Form, Method,..) AND the existing data from one instance to another.
The application itself is no big problem. We can create a PackageDefinition and use the existing Export/Import tool for transfer.
But what about the data?
In theory we could also create a PackageDefinition for the data. But the generated package do not contain all item properties. The exported items do not contain important properties like created_on/modified_on, permission_id, id, config_id, current_state, state, etc. .
But it´s important for me that the data is transferred with all of these properties.
How would you solve this task? There are many possible ways, but which one would you use?
My current ideas:
- SQL Insert select?
- CSV SQL export/import?
- AML export/import?
- transfer via IOM/REST connection?
- Innovator Admin?
- BatchLoader?
- Shell script?
- SQL script?
- Hire intern that type in the data manually?
- Something else?
I want to avoid using Excel or CSV as transfer medium. I want to use a concept that is reusable and maybe can be automated.
In addition I have to modify some of the data before import. These should be integrated into the process.
Any ideas and thoughts welcomed!
Thanks!
Angela