Hi! I have a new project and I was wondering if some could point me to how I would design the data structure. It is a supplier portal and one of the modules will be for documents. 1. We have 4 locations and each location has its own data. 2. Documents and zipped files will be uploaded to the portal. 3. Each location has keep its separate data stores. How can I best accomplish the document and zipped files and how are they stored in SQL Server 2005?
My preference is to keep files in the file system and data in the database. In that way I would work on a file server having the structure you want to store your files and then simply have your database contain the UNC for each file. If you are also working on the document transfer solution then I would expect SSIS to be able to manage the transfer from one location to another if you need to.