SIARD database archive

SIARD stands for Software Independent Archiving of Relational Databases and is an open format developed by the Swiss Federal Archives. SIARD is a data archival format (standardized XML meant to reliably read and write databases regardless of its original format). Full Convert can read and write SIARD format efficiently.

By its structure, SIARD is a collection of files compressed as ZIP archive. It contains metadata information and data, including large binary data items.

Full Convert supports SIARD database directly.

SIARD data types we support

Integral

bigint, int (integer), smallint

Decimal

decimal (numeric, dec), double precision, float (real)

Text

char (character), clob (character large object), nchar (national character, national char), nchar varying (national char varying, national character varying), nclob (nchar large object, national character large object), varchar (char varying, character varying)

Binary

binary, bit, varbinary (binary varying, bit varying)

Date/Time

date, time, timestamp, timestamp with time zone (time with time zone)

Large objects

blob (binary large object), clob (character large object), nclob (nchar large object, national character large object), xml

Other

boolean, interval

Export SIARD database

It may make sense to migrate your data away from SIARD. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current SIARD database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.