A
A
Akhat Moldabekov2016-08-09 10:55:26
Yii
Akhat Moldabekov, 2016-08-09 10:55:26

You need to unload the database from 1C 8.2 to regular MySQL. How to pull out all data from 1C v8.2?

There is a network server, but which base is 1C 8.2: enterprise.
I need to upload all the data from there somewhere, either to a text file or directly to the traditional MySQL database
. But I have never worked with 1C and its database. I read about the options for transferring data to XML and from there using php-scripts, or others to transfer to the database. Only I have no idea how the architecture of the database is arranged there.
And how is the whole thing done?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Andrey, 2016-08-12
@ahatnya

1 option. Directly through a com-connection, you can overtake all the information you are interested in.
Option 2. Through any file formats convenient for you (dbf, txt, xml, xls ......)
If you are interested in something specific, please ask

P
Pan Propan, 2016-08-09
@mgis

Go to the configurator and upload the file to .dt

M
MishaHD, 2016-08-15
@MishaHD

I think the author must first understand the problem with which he had to face. What is the purpose of migrating the entire database in MySQL?
If the goal is to switch from a file (possibly a database of its own format) to some other DBMS, then there is a limited choice of DBMS described in the documentation. The most popular are MS SQL and Postgre. The 1c database cannot be raised to MySQL - this is not supported by the platform.
If the goal is to pull out part of the data, then you can already use different ways to export data. You can upload data to files, you can use com, you can use odbc. You can also use the "External Data Sources" object

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question