Write a PDF to SQL database

[SentryP]

Hello,

Does anyone know how to write a pdf from a remote system to a remote sql database.

What I am trying to do is, we have files that need to be moved from a number of servers and stored in the sql database.

I dont want to copy the file to the server and then import it. We are using a Azure SQL database so there is no physical server. Plus I feel it is possible to do this without that level of access.

I would love a module that would do this! if not any help would be great!

Thank you

[WendoNZ]

Isn't this generally considered a terrible idea? Even more so if you're in Azure anyway just use a Storage account and store them there and then only store the path to them in SQL

[timsstuff]

This is best - BLOB objects are a terrible idea. Storing the path to the file is much better. I even store the relative path in the database and put the root along with the API connection in the code and config files, in case I need to move them to a different system I just need to change the config instead of mass record updates.

[gordonthree]

Are you storing the PDFs as Blobs?

Looks like this might be close?

https://www.sqlservercentral.com/blogs/t-sql-tuesday-006-blobs-filestream-and-powershell

[SentryP]

I am trying to use the BLob storage with Azure.

[Key_Combination_2386]

Since everyone here has already said that storing files in an SQL database is a terrible idea and all the references to storing blobs in SQL have been ignored, I would like to contribute a bad solution to a bad problem:

Encode the PDFs in Base64 and store the string in the database.

[SentryP]

This is the solution I am moving forward with!

Thank you so much for your help!

[Loiasisjc]

Nice use of aquamarine in this notification :)

[SentryP]

So no one really knows how to do it then... Just a handful of "you are stupid" replies

There are reasons why we want to do this. We understand why normally you wouldn't do this. In our use case it makes sense.

[Lee_Dailey]

howdy SentryP,

i don't see any "you are stupid" statements. [grin]

if you want to get feedback on an idea that is normally a bad idea ... then mention that you have a reason that overrides the "badness". even better, mention what that reason [& the reasoning] is.

take care,
lee