March 12, 2013 at 10:21 pm
Hi,
i have to design an application to read all text files from a folder and store in sql server 2005.
each file has an average size of 1 MB.
User can search and view all data by User Interface.
I wish to enquirer if it is good practice to store text file content in tables.
text file data is in alphanumeric and continuous format.
Please suggest me how can i do this and is there any other way to do it.
Thanks.
March 12, 2013 at 11:22 pm
The data in the file, is it delimited or is it just paragraphs of information?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 13, 2013 at 8:11 am
text is in given format.
23455677880453421343536457645756234523532453425532532455654734653
23454565476878967635243523543463475656768456743345234523457547848
83973659807346098796508796508730698760987609834873748945956043056
March 13, 2013 at 1:29 pm
That text does not appear usable or searchable. I don't know why they would want to store or search it. But if the business requests it, sure store it in a field (varchar(max) and not text). If you weren't on 2005, I'd say to also look at compressing the data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply