You can use SQL Management Studio if you already have your 1C:Enterprise data in SQL format. My question was how to get my 1C:Enterprise database in SQL format without having 1C:Enterprise Server? My database now in file format.
Normally this is done by concatenating all object's text fields separated by some separator character and then encrypting this long string in one operation and storing the result in one additional field. And all these text fields are replaced by hash of their content. Shouldn't take too much time. In Java Spring Boot such operation - quite OK, doesn't create too noticeable delay.
Joined: Jan 17, 2023
Company: Techatom Pvt Ltd
Hello this is Gulshan Negi Well, yes it is possible means a custom script or utility is required for converting.dt files to.sql files. The process involves understanding the structure of the .dt files, determining the appropriate SQL commands, and parsing the data to generate SQL INSERT statements. Thanks
Could you try to do this and then share your experience please. I think many developers will be interested in this.
Alex, I tried to encrypt and decrypt quite substantial document with JWT: https://github.com/pintov/1c-jwt. Works quite brisk. Time spent for encryption and decryption of all document header attributes and all table section attributes took less than 1 sec. It's a symmetric encryption which should be enough for a decent information security. Quite good, I think. Shouldn't create a serious overhead for the whole system.