./standalone.sh -Dkeycloak.migration.action=export -Dkeycloak.migration.provider=singleFile -Dkeycloak.migration.file=dsgapi.json -Dkeycloak.migration.realmName=DSG_API
I then try to import it into another new instance. However I got this error. Any idea? Is this possible? I can send the json file if it helps.
12:08:10,574 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-26) SQL Error: 23505, SQLState: 23505
12:08:10,574 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-26) Unique index or primary key violation: "UK_B71CJLBENV945RB6GCON438AT_INDEX_7 ON PUBLIC.CLIENT(REALM_ID, NAME) VALUES ( /* key:17 */ null, null, null, null, null, 'security-admin-console', null, null, null, null, null, null, null, null, 'cc0823c1-dab8-4f17-9b23-b04708d3b523')"; SQL statement:
insert into CLIENT (ALLOWED_CLAIMS_MASK, ENABLED, FULL_SCOPE_ALLOWED, NAME, NOT_BEFORE, PUBLIC_CLIENT, REALM_ID, SECRET, BASE_URL, BEARER_ONLY, MANAGEMENT_URL, SURROGATE_AUTH_REQUIRED, DTYPE, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'ApplicationEntity', ?) [23505-173]
12:08:10,576 INFO [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default task-26) HHH000010: On release of batch it still contained JDBC statements