All geek questions in one place

Universal backup / retrieved database format

Is there a universal backup / extracted database format?

I’ll explain where I come from: our application supports several database providers, DB2, MsSql, MySql and Oracle. Currently, when we request a backup from a customer, they must make a full backup in a specific provider format.

We have a small but powerful homegrown utility that allows us to fully or partially import and export any database provider. Unfortunately, the general extent format is dBase tables, which do not work very well, because now we are using SQL field types that are not supported.

The solution is to use the existing standard backup / extent format, if one exists. Although I do not mind inventing my own format, the industry standard format will have more options.

Is there one or should I invent it?

Thanks in advance,

Stephen.

+3
source share
5 answers

The only universal export format is some changes to the text dump theme.

There are several possible formats - fixed or split (or split). When limited, it may be CSV or some other related format. Exclusion conventions, especially for inline newlines, tend to be special.

, , BLOB- - Base64, hex,... , , ...

XML , , XML- DTD.

0

FYI: SQLite . :

  • , .
  • , .
  • .
  • .
  • .
  • .
  • SQLite.

7 , , ( ) , , .

+1

XML? CSV?

0

, ( ), CSV.

compress .

0

Source: https://habr.com/ru/post/1719547/

More articles:


All Articles