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.
| Author |
Topic |
|
brace77
Starting Member
25 Posts |
 Posted - 2009-01-22 : 04:22:30
|
| I am writing an application that handles documents outside sqlserver, I just use a SQL Server table to keep track of the documents (I store there the shared network path to the file), like:DOC_ID; DOC_PATH (of course real case is more complex)Now I would like to move documents inside SQL Server, these are my questions:1) In the Express edition do the documents "use" the 4GB DB limit? I mean, let's say my tables take 200MB and I have 10GB of documents... So do I have 10,2 GB of data or 200MB? I mean with 200MB of tables + 10 GB of tables am I exceeding the 4GB limit? (I've heard that SQL Server has a document repository that is somehow distincted from the "tables DB"...)2) At present to connect to my server when outside the LAN I use a VPN, in this way I can access the documents too. But I am considering moving to "open IP method" to connect to DB, in this way I would not be able to access the documents, because without a VPN i wouldn't see the network path. So this is the reason why I am thinking about moving documents to SQL server: so I can upload/download documents to my application without using a VPN.May you please comment on this idea?Thanks a lot. |
|
|
|
|
|
Storing documents in SQL Server Express