How can I export some Blog posts from our Sql Server, to a file?
We have a simple website that contains (take your pick, for this example) blog posts / q & a questions / whatever. People upload text (single sentences to paragraphs .. including some white listed/approved html).

I need to export this data into .. a file? something .. so I can give it to someone else.

eg. sample schema

    Id INT
    Title VARCHAR(100)
    UniqueUrl VARCHAR(100)
    Content VARCHAR(MAX)
    ModifiedOn DATETIME
    PublishedOn DATETIME
    CreatedByUserId INTEGER

Is there any way I can export this data into a format that is simple to give to another person to import? I have no idea what they will import it into .. so i was guessing a csv or excel format might be sufficient. That said, one of the fields contains VARCHAR(MAX) which can have paragraphs of text.

Anyone have any suggestions?

How can I export some Blog posts from our Sql Server, to a file?
===

We have a simple website that contains (take your pick, for this example) blog posts / q & a questions / whatever. People upload text (single sentences to paragraphs .. including some white listed/approved html).

I need to export this data into .. a file? something .. so I can give it to someone else.

eg. sample schema

    Id INT
    Title VARCHAR(100)
    UniqueUrl VARCHAR(100)
    Content VARCHAR(MAX)
    ModifiedOn DATETIME
    PublishedOn DATETIME
    CreatedByUserId INTEGER

Is there any way I can export this data into a format that is simple to give to another person to import? I have no idea what they will import it into .. so i was guessing a csv or excel format might be sufficient. That said, one of the fields contains VARCHAR(MAX) which can have paragraphs of text.

Anyone have any suggestions?
