Insert files into external SQL database

dgaber

Hey everybody,

Here's my problem:
We've created a codeunit which creates xml and pdf files and sends them out automatically to the customers. Now I want to store these files in external database (to avoid growth of NAV database).

I've already got set up reading from that database and I can run stored procedures without any problems. Problem arises, when I want to pass a file as a parameter.

As much as I could learn from the internet, my problem should be solved with ADO Stream Automation, but I can't find any examples or tips anywhere.

Can you please help me?

Thank you

tinoruijs

Why don't you just save the files on a drive?

dgaber

Saving files on HDD's is the thing we're trying to avoid with above mentioned process.

These files will be used not just in NAV but also in SharePoint and external web applications - so storing them into a database is a logical and most compatible solution.

tinoruijs

dgaber wrote:

Saving files on HDD's is the thing we're trying to avoid with above mentioned process.

These files will be used not just in NAV but also in SharePoint and external web applications - so storing them into a database is a logical and most compatible solution.

And when you synchronize the sharepoint-docs to your server? Then the files are automaticly uploaded to Sharepoint when you save a file in the sharepoint-directory on your server.

dgaber

Once again. Our goal is not to store files in filesystem, but to store them in SQL DB. And files must be sent to DB from NAV because they must be equipped with NAV data as metadata in table.

We can go back and forth on why we want to do this and why we don't want to use filesystem, but that is not the reason I opened this thread.

So... once again... can anyone help me out on this one?