how to store text file content into sql server 2005 database

  • 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.

  • 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

  • text is in given format.

    23455677880453421343536457645756234523532453425532532455654734653

    23454565476878967635243523543463475656768456743345234523457547848

    83973659807346098796508796508730698760987609834873748945956043056

  • 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