Nuclos data migration: import structure definition, SQL, JDBC, ID factory, idfactory, T_EO_, legacy system, CSV.

globe with meridians Language: Deutsch · English

light bulb Migrating data into Nuclos

Import existing data into Nuclos – import structure definitions for simple cases, SQL/a program for complex ones.

On this page

Ways to import existing data from legacy systems into Nuclos.

Migration with built-in tools

Via import structure definitions. Only partly suitable for complex migrations (restructuring, reformatting): manual intermediate steps are usually required (CSV export, deletion before a re-run, matching formats/character sets), clarity and logging suffer, and reformatting with the help of additional data sources is not possible.

Migration with SQL/a program

For complex cases, a SQL script (same DBMS) or a program (different DBMS, e.g. via JDBC to both databases) that performs the migration synchronously and automatically is recommended.

Always assign IDs via the Nuclos ID factory – syntax differs by DBMS:

-- PostgreSQL
INSERT INTO T_EO_KUNDE VALUES (NEXTVAL('idfactory'), ...);
-- Oracle
INSERT INTO T_EO_KUNDE VALUES (IDFACTORY.nextval, ...);

Related pages

gear Fast and generic database import/export

Snapshots.

Öffnen →