| Auszug |
|---|
|
Nuclos data migration: import structure definition, SQL, JDBC, ID factory, idfactory, T_EO_, legacy system, CSV. |
Language: Deutsch · English
Migrating data into Nuclos
Import existing data into Nuclos – import structure definitions for simple cases, SQL/a program for complex ones.
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
Ways to import existing data from legacy systems into Nuclos.
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.
| Warnung |
|---|
|
Always assign IDs via the Nuclos ID factory – syntax differs by DBMS: | Codeblock |
|---|
| -- PostgreSQL
INSERT INTO T_EO_KUNDE VALUES (NEXTVAL('idfactory'), ...);
-- Oracle
INSERT INTO T_EO_KUNDE VALUES (IDFACTORY.nextval, ...); |
|
Related pages
Fast and generic database import/export
Snapshots.
Open →
