October 25, 2018 at 10:11 am
I need to create a project to convert some Word files from file server into SQL server.
What data type is the best way to store Word data?
October 30, 2018 at 8:20 am
adonetok - Thursday, October 25, 2018 10:11 AMI need to create a project to convert some Word files from file server into SQL server.
What data type is the best way to store Word data?
That requirement is much too vague. What are you planning to do with the data once it's in SQL Server?
If you are expecting to have a .Net application read the data, and present it to the user in MS Word, that's
probably do-able, but my question would be why? No matter what your reason, your data type is most
likely going to have to be varbinary(max), which is not going to be indexable. nvarchar(max) may also be
an alternative, but again, the question is what are you going to gain from placing the document data in the
database? Also, certain features of MS Word documents aren't going to appear as part of the document
text and may only be accessible programmatically from .Net, so how are you planning to handle any of
those kinds of features in terms of data storage? Again, what's the overall objective? What will having
these documents in the database do for you?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 30, 2018 at 11:08 am
adonetok - Thursday, October 25, 2018 10:11 AMI need to create a project to convert some Word files from file server into SQL server.
What data type is the best way to store Word data?
Exactly as Steve said - what are you going to do with those files?
I've done nvarbinary, pointers to file system, third party rbs, filestream, nvarchar that I can think of. The direction always depended upon how the files were used from a SQL Server perspective.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply