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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2004-04-06 : 10:47:16
|
| Hi,I am planning on building a database to store resumes of candidates. One of the features i would like to provide is to do keyword searches on resumes.This database is going to be a for a small user base. Is MSDE a good choice, also can we upload resumes into msde database, and can i do keyword searches on uploaded resumes. Any feedback suggestions are appreciated.RamdasRamdas NarayananSQL Server DBA |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-06 : 15:01:23
|
| Well..... Maybe. You can store documents in SQL Server using the TEXT or NTEXT data types. I've heard you can even store documents that are in Word format, but I've never tried that. In fact, I try to avoid these datatypes as much as I can. I think you can implement FULL TEXT searching on TEXT fields, but I'm not sure if that handles Word format or if it has to be plain text.So, I'd encourage you to do some research (such as BOL) on TEXT, NTEXT, and FULL TEXT SEARCH to get familiar with the hoops you'll have to jump through.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-04-06 : 23:48:55
|
| I'd suggest using MS Indexing Service instead. It can full-text index pretty much any file format, and you avoid storing the files in the database. While you CAN do it that way, there's no benefit (and a lot more aggravation) over using Indexing Service. You can create a linked server to it from your SQL Server and query it just like any other data source too. Books Online and MSDN will have more details on how to set up Indexing Service as a linked server. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-07 : 18:48:15
|
quote:
Originally posted by robvolk
I'd suggest using MS Indexing Service instead...You can create a linked server to it from your SQL Server and query it just like any other data source too.
D'OH! I knew that, but forgot about it. I guess that's why you are the MVP...--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|
|
|
|
Resume Storing in MSDE