I have an application that currently uses Access 2000 as a back end. I want to recreate this application using an SQL Server.
The applications core functionality is a document management system. I am copying PDF files to a server location and changing their attributes in an attempt to hide them or make it more difficult to accidentally delete. Ideally, to make this a more grown-up application is to store these PDF's in the SQL Server itself. I'm not really fluent in SQL Server and was wondering if anyone can offer me some advice on how this can be done. I am assuming this is possible, but I don't know what data type to use in the field definition when I create it, and I am not exactly sure how to persist the file.
And if any moderators are watching, is this the appropriate place to post a SQL Server question - or is this topic supported in any lounge forum?