How to transfer table data from one Innovator instance to another fast and easy?

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! Smiley

Thanks!

Angela

Parents Reply Children
  • Basically this one is a test balloon for my own update concept.Sunglasses

    When we one day get a new open release, I at least want to try to update. Of course this is easier said then done. With my current main database, I probably need 2 years of preparation (and cleanup) to cover everything.

    But I made first tests and was able to transfer some Users+Alias from one db to another with SQL. It´s actually a pretty dumb concept. 

  • Angela,

    I would love to see how you are doing this.  I am currently refactoring our database, moving parts and documents from custom made ItemTypes to the OOTB ItemTypes.  I have reports to gather the information I am looking for, then I put that into an Excel spreadsheet, then use the spreadsheet to do a mass import.  It works, but it is a time consuming process (the reports can take a long time to run, if I am gather too much data they will crash).

    Nate