Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to store text file content into sql server 2005 database Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 10:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 17, 2013 10:18 PM
Points: 21, Visits: 133
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.
Post #1430203
Posted Tuesday, March 12, 2013 11:22 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 21,733, Visits: 15,424
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1430212
Posted Wednesday, March 13, 2013 8:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, March 17, 2013 10:18 PM
Points: 21, Visits: 133
text is in given format.
23455677880453421343536457645756234523532453425532532455654734653
23454565476878967635243523543463475656768456743345234523457547848
83973659807346098796508796508730698760987609834873748945956043056
Post #1430414
Posted Wednesday, March 13, 2013 1:29 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 21,733, Visits: 15,424
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1430598
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse