Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Folder content to a database

Author  Topic 

kapil819
Starting Member

1 Post

Posted - 2010-10-08 : 15:35:02
Hi,

Am running a Windows Server on my system which acts as a source of files pdfs etc on the local LAN. I have created a website thru which others can access these files. Currently am using IIS to display the contents of the shared folder.

What I am now thinking is of making a SQL database of all the files present in the folder along with its location. This database should be updated automatically through scripting as and when a new file is added to the folder.

Any ideas, how to go about it? How do i add data automatically to database?

davebatt
Starting Member

17 Posts

Posted - 2010-10-19 : 07:14:19
Best way would be to create a web page that has an upload feature, then when the file is uploaded you can run an insert command on the database
Go to Top of Page
   

- Advertisement -