Project

General

Profile

Actions

Feature #2613

open

ARCHE export: SQL dump

Added by Bernhard Koschiček-Krombholz 6 months ago. Updated 14 days ago.

Status:
Assigned
Priority:
Normal
Category:
Data import/export
Target version:
Start date:
2025-09-03
Estimated time:

Description

Currently, the ARCHE export will dump the complete model, public and import schema without differentiation between project entries (defined by type ID) or other entries.

Questions, should the dump...
  • update an existing database (this means, losing the unique IDs and can be difficult to develop)
  • be inserted into a clean OpenAtlas instance (4_data_type.sql can be replaced with the dump)
  • just exist as @INSERT@s and interested people have to deal how to get the data out of it
Keep only data if entities have a corresponding case study:
  • Annotation (text and image)
  • Geometries
  • Hierarchy and Types
    and delete all other

Related issues 1 (0 open1 closed)

Related to OpenAtlas - Feature #2568: Admin interface for generating ARCHE dumpsClosedBernhard Koschiček-Krombholz2025-06-24Actions
Actions #1

Updated by Bernhard Koschiček-Krombholz 6 months ago

  • Related to Feature #2568: Admin interface for generating ARCHE dumps added
Actions #2

Updated by Bernhard Koschiček-Krombholz 5 months ago

  • Status changed from Acknowledged to Assigned
Actions #4

Updated by Bernhard Koschiček-Krombholz 14 days ago

  • Description updated (diff)
Actions

Also available in: Atom PDF