Now I am considering options to store the documents on the server I'll have PDF documents mostly around 1 Million or so,those will store into a SQL Server table I am aware that I will reach the 8TB, I'm not sure about limit .mdf size of SQL Server Enterprise edition. After the PDF files are stored they can be downloaded and viewed via browser after entering the related order number. Here is some additional information: -The PDF files will have a size of around 1-2 MB. each -SQLServer 2016 Enterprise -2TB SSD*4
my table of orders by a varbinary(MAX) column and store the PDF document directly into that binary field.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)