How to transfer the 1C database to MySQL, PostgreSQL or something like that?

Question

MySQL

The thing is, there is an xml file for 2 million. lines, in fact base 1C. You need to somehow transfer it to SQL or something like that. I'm thinking of registering cloud storage for 1C, deploying the whole thing there and somehow exporting it in the right format. While I'm trying, I hope that smart and kind people will advise some other way. Thank you in advance. :)

Answer 1

The question is very old, but it's still indexed and doesn't have an answer. Therefore, we turn on the "psychic" mode :)

there is an xml file for 2 million. strings, essentially base 1C

Normally, 1C databases are not unloaded in XML. In XML, only the configuration or its elements can be unloaded. The database is regularly uploaded to the *.dt archive.
Therefore, the author of the question has an upload either using the "XML Data Exchange" processing, which allows at least all data to be uploaded in XML format for loading into an identical configuration. Or upload using the "Data Conversion 2.0/1" configuration, which uploads the specified data in the XML format, which is described in this service configuration.

You need to somehow transfer it to SQL or something like that.

The MsSQL product is probably mentioned, since SQL is a query language. Almost all modern DBMSs support importing data from XML files. Here is the MsSQL doc .

I'm thinking of registering cloud storage for 1C, deploying the whole thing there and somehow exporting it in the right format.

If you have access to 1C, then it’s easier to immediately upload it in the right format. The second option is to load raw data into a new database from XML files, and then edit the table structure and clean up the "garbage" on the spot. Alternatively, you can use SELECTs to unload only the necessary information into files for subsequent loading in the final database.

Answer 2

Expand PostgreSQL, start a database in it and fill in your XML g.zeos.in/?q=%D1%83%D1%81%D1%82%D0%B0%D0%BD%D0%BE% in the standard 1c ways .
..

Answer 3

What is contained in these two million lines of xml file?
Does it contain metadata?