Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Chuck Tomasi
Tera Patron

Description

Mimeo copies hierarchical data between tables while preserving sys_ids on reference fields all without scripting! This is great for moving data from a global app to a scoped app, or updating data on a secondary table for reporting or limited access use cases. Using familiar tools such as the auto mapping feature and mapping assist borrowed from import set transform maps, you can quickly constructed a map of tables and fields to copy. Mimeo identifies the reference fields that need new sys_ids and updates them to point to new records in the target tables.

Mimeo also allows you to quickly debug and retest your maps. These maps can be captured in update sets to easily migrate them to other instances for additional testing and production.

Common use cases

  • Migrate data from a global app's table structure to a scoped app's tables
  • Replicate (all or part of) data from one set of tables to another for reporting or users with separate ACL structure

Download

Compatibility

  • January 3, 2017: Tested with Geneva, Helsinki (P7), and Istanbul (P0)

Explanation/Demonstration Video

4 Comments
Mike Wilson
Tera Contributor

Looks very useful.  Have you tested this on any more recent versions / any plans to update it? 

Chuck Tomasi
Tera Patron

Hi Mike,

 

I haven't had a chance to test it recently. Adding it to my "to do" list.

Ranjana Goel
Tera Contributor

Looks interesting. Is this app compatible with Utah? Is there any testing done on this? We are looking to move data from one instance to another instance table and looking for some expert solution.

Not applicable

Is there a better or newer approach for moving data from a global app to a scoped app?
Otherwise, I plan on testing this in Utah...