Language: Deutsch · English
Migrating data into Nuclos
Import existing data into Nuclos – import structure definitions for simple cases, SQL/a program for complex ones.
KONZEPT DEVELOPER UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X
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.
ID assignment
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
Überblick
Inhalte