{"id":6342,"date":"2014-11-20T15:39:15","date_gmt":"2014-11-20T20:39:15","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=6342"},"modified":"2017-11-07T08:59:46","modified_gmt":"2017-11-07T13:59:46","slug":"nextform-multitable-migration-wizard","status":"publish","type":"post","link":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/","title":{"rendered":"DB Migration with the NextForm Multi-Table Wizard"},"content":{"rendered":"

The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm<\/a> software moves data from\u00a0one database to another<\/a>, multiple tables at a time. IRI Voracity<\/a> platform users can also make use of this feature.<\/p>\n

Following is an example of migrating\u00a0data from two MySQL\u00a0tables into Oracle. The tables do not have to exist in the target location; however, in this example they do as empty tables. The target table ORDERS_NF will have a masked “TOTAL” column.<\/p>\n

Here are the tables as they exist in the source MySQL database’ test Schema, as shown in the IRI Workbench<\/a> GUI1<\/a><\/sup> for NextForm:<\/p>\n

\"image001\"<\/a><\/p>\n

The wizard starts by asking\u00a0which DB sourcing and targeting\u00a0method will be used. NextForm supports both IRI\u00a0FACT<\/a> (Fast Extract) and ODBC<\/a>\u00a0for data acquisition. Data population can be through bulk loads (for which NextForm will write the load utility’s control file) or ODBC. If you use flat files and have a Voracity (or IRI CoSort) licenses, that load file can be pre-sorted on the primary index key, by-passing the loader’s sort function and making the load faster<\/a>.<\/p>\n

On the second screen, select the\u00a0source tables you will migrate. There is a second table selected down in the non-visible section of the scroll box:<\/p>\n

\"image003\"<\/a><\/p>\n

You can use various field rules to transform your data before it is loaded into the target tables. In this case, the TOTAL column will be masked with the number \u201c1\u201d:<\/p>\n

\"image005\"<\/a><\/p>\n

After selecting the target database and schema, the summary page shows the information entered in the wizard pages, along with any matched rules and existing matched tables:<\/p>\n

\"image007\"<\/a><\/p>\n

The \u201cnew batch\u201d folder shows the scripts that were created by the wizard. Because IRI products run on\u00a0the command-line, the only file that needs to be executed is the batch file. It bundles\u00a0the execution of all\u00a0the scripts automatically.<\/p>\n

In the editing window shown below are the two scripts that extract the data from the source file, and transform it before saving it to two text files (CUSTOMERS_NF.out and\u00a0ORDERS_NF.out). The highlighted line shows the transformation that will take place on the \u201cTOTAL\u201d field.<\/p>\n

\"image009\"<\/a><\/p>\n

After the batch file is executed, the data is now visible in the target tables. The \u201cTOTAL\u201d column now displays 1’s where actual data used to be. This is helpful when setting up new database systems when\u00a0you don\u2019t want your production data visible during testing.<\/p>\n

\"image011\"<\/a><\/p>\n

If for some reason your migration wasn\u2019t successful, the log files that are created during the execution of the batch file are helpful in\u00a0determining why. For instance, if you had data in the wrong data type or format, the log file will display that.<\/p>\n

In the following case, the transfer was successful:<\/p>\n

\"image013\"<\/a><\/p>\n

NextForm includes this easy-to-follow migration wizard for your multi-table data migration projects. Once your rules are set-up, it is also quite easy to apply those mapping\u00a0rules during your migration to save steps later.<\/p>\n

Email nextform@iri.com<\/a> if you have any questions;\u00a0be sure to specify that you are writing\u00a0about the DBMS edition<\/em><\/a> of NextForm.\u00a0For assistance in migrating complex constraints, triggers, SQL procedures and\/or database applications, contact\u00a0IRI Professional Services<\/a>, or a third-party database expert.<\/p>\n

 <\/p>\n

\n

1. From the same GUI, but with an IRI FieldShield<\/a> or IRI CoSort<\/a> (SortCL<\/a>) license, your\u00a0migrations can include data masking\u00a0and data transformation functions, respectively. IRI RowGen<\/a>, compatible with NextForm metadata, works with\u00a0the same GUI’s\u00a0Data Source Explorer to generate structurally and referentially correct test data in\u00a0target tables (needing no\u00a0production data).\u21a9<\/a><\/sup><\/p>\n","protected":false},"excerpt":{"rendered":"

The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm software moves data from\u00a0one database to another, multiple tables at a time. IRI Voracity platform users can also make use of this feature. Following is an example of migrating\u00a0data from two MySQL\u00a0tables into Oracle. The tables do not have to exist in the target<\/p>\n

Read More<\/a><\/div>\n","protected":false},"author":43,"featured_media":12071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[31,91,3],"tags":[592,159,588,553,593,589,587,590,591,75,595,594],"class_list":["post-6342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-migration","category-iri-workbench","category-vldb-operations","tag-data-population","tag-database-applications","tag-dbms-edition","tag-iri-nextform","tag-migrating-complex-constraints","tag-move-data-from-one-database-to-another","tag-multi-table-migration-wizard","tag-multiple-tables-at-a-time","tag-mysql-tables-into-oracle","tag-odbc","tag-sql-procedures","tag-triggers"],"acf":[],"yoast_head":"\nDB Migration with the NextForm Multi-Table Wizard - IRI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DB Migration with the NextForm Multi-Table Wizard - IRI\" \/>\n<meta property=\"og:description\" content=\"The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm software moves data from\u00a0one database to another, multiple tables at a time. IRI Voracity platform users can also make use of this feature. Following is an example of migrating\u00a0data from two MySQL\u00a0tables into Oracle. The tables do not have to exist in the targetRead More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2014-11-20T20:39:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-07T13:59:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"425\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Claudia Irvine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Claudia Irvine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\"},\"author\":{\"name\":\"Claudia Irvine\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\"},\"headline\":\"DB Migration with the NextForm Multi-Table Wizard\",\"datePublished\":\"2014-11-20T20:39:15+00:00\",\"dateModified\":\"2017-11-07T13:59:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\"},\"wordCount\":599,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg\",\"keywords\":[\"data population\",\"database applications\",\"DBMS edition\",\"IRI NextForm\",\"migrating complex constraints\",\"move data from one database to another\",\"Multi-Table Migration Wizard\",\"multiple tables at a time\",\"MySQL tables into Oracle\",\"ODBC\",\"SQL procedures\",\"triggers\"],\"articleSection\":[\"Data Migration\",\"IRI Workbench\",\"VLDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\",\"name\":\"DB Migration with the NextForm Multi-Table Wizard - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg\",\"datePublished\":\"2014-11-20T20:39:15+00:00\",\"dateModified\":\"2017-11-07T13:59:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg\",\"width\":640,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/beta.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DB Migration with the NextForm Multi-Table Wizard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#website\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/beta.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/beta.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0\",\"name\":\"Claudia Irvine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g\",\"caption\":\"Claudia Irvine\"},\"url\":\"https:\/\/beta.iri.com\/blog\/author\/claudiai\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DB Migration with the NextForm Multi-Table Wizard - IRI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/","og_locale":"en_US","og_type":"article","og_title":"DB Migration with the NextForm Multi-Table Wizard - IRI","og_description":"The “Multi-Table Migration Wizard” in the DBMS edition of IRI NextForm software moves data from\u00a0one database to another, multiple tables at a time. IRI Voracity platform users can also make use of this feature. Following is an example of migrating\u00a0data from two MySQL\u00a0tables into Oracle. The tables do not have to exist in the targetRead More","og_url":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/","og_site_name":"IRI","article_published_time":"2014-11-20T20:39:15+00:00","article_modified_time":"2017-11-07T13:59:46+00:00","og_image":[{"width":640,"height":425,"url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","type":"image\/jpeg"}],"author":"Claudia Irvine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Claudia Irvine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#article","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/"},"author":{"name":"Claudia Irvine","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0"},"headline":"DB Migration with the NextForm Multi-Table Wizard","datePublished":"2014-11-20T20:39:15+00:00","dateModified":"2017-11-07T13:59:46+00:00","mainEntityOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/"},"wordCount":599,"commentCount":0,"publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","keywords":["data population","database applications","DBMS edition","IRI NextForm","migrating complex constraints","move data from one database to another","Multi-Table Migration Wizard","multiple tables at a time","MySQL tables into Oracle","ODBC","SQL procedures","triggers"],"articleSection":["Data Migration","IRI Workbench","VLDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/","url":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/","name":"DB Migration with the NextForm Multi-Table Wizard - IRI","isPartOf":{"@id":"https:\/\/beta.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage"},"thumbnailUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","datePublished":"2014-11-20T20:39:15+00:00","dateModified":"2017-11-07T13:59:46+00:00","breadcrumb":{"@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#primaryimage","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","width":640,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/beta.iri.com\/blog\/vldb-operations\/nextform-multitable-migration-wizard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beta.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"DB Migration with the NextForm Multi-Table Wizard"}]},{"@type":"WebSite","@id":"https:\/\/beta.iri.com\/blog\/#website","url":"https:\/\/beta.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/beta.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beta.iri.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beta.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/beta.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/72af50bbb317610e193e96392081f9b0","name":"Claudia Irvine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beta.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb33dee44756bd13ac23f1342c2bb7b2?s=96&d=blank&r=g","caption":"Claudia Irvine"},"url":"https:\/\/beta.iri.com\/blog\/author\/claudiai\/"}]}},"jetpack_featured_media_url":"https:\/\/beta.iri.com\/blog\/wp-content\/uploads\/2014\/11\/pigeons-1.jpg","_links":{"self":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6342"}],"collection":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=6342"}],"version-history":[{"count":21,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6342\/revisions"}],"predecessor-version":[{"id":11817,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/posts\/6342\/revisions\/11817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media\/12071"}],"wp:attachment":[{"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=6342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=6342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beta.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=6342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}