2
2
20ivs2019-07-16 14:28:26
linux
20ivs, 2019-07-16 14:28:26

How to extract files with normal names from SQL?

Welcome all!
There is a certain MSSQL base, it contains paths to a certain collection of files that are completely meaningless and not structured in any way. Stupidly in the directory lying around like this - iffpohpw8oiupwro9poksefuy.
At the same time, somewhere in the bowels of SQL there are records about these files in a human-readable form. Let's say iffpohpw8oiupwro9poksefuy, he is - Pipe xs of what diameter.pdf
The task is as follows.
You need some tool to upload these files to another directory with the assignment of normal names to them. And it is desirable to structure.
Question. What tools can be used for this? It's a good idea to do this on Linux to get around Windows' 255-character filename limit.
With SQL I am not on friendly terms, strongly do not kick.
Below is an example structure.

spoiler
5d2db48d75dbc309776363.png

UPD: Thank you all for the answers, we will try.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Stanislav Valsinats, 2019-07-16
@20ivs

And this is all in one table - file names and human names ??
In general, SQL is natively able in CSV, and parsing CSV is quite sane in any language, even bash probably can.
If in different tables - then display the combined table, connecting them by fields (let's say ON t1.iffpohpw8oiupwro9poksefuy = t2.iffpohpw8oiupwro9poksefuy)
Further in CSV and forward.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question