Post reply

Exporting a database to a flat file

  • February 19, 2004 at 10:48 pm

    #163137

    Is it possible in SQL Server to export and entire database to a flat file? By this I mean all the data and database objects.

  • February 19, 2004 at 11:30 pm

    #494857

    You can use BCP to export all Data from all Tables to flat files. As for the Objects, just script them!

    Kindest Regards,

  • February 19, 2004 at 11:56 pm

    #494862

    MrSQL is right.   You may also look into DTS packages and setting something up to export the scripts for the objects.

    I have  a process in place that extracts all of the user objects (DDL and DML) and security to a script.   I love it!! 


    "Keep Your Stick On the Ice" ..Red Green

  • February 20, 2004 at 1:41 am

    #494875

    Care to elaborate on your process jeffwe ????

  • February 22, 2004 at 7:02 pm

    #495074

    I'm assuming jeffwe is talking about using the BCP Process I have mentioned in a DTS Package!

    Kindest Regards,

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply