Generate script for data

  • Microsoft has just released a tool which will generate a script file containing both the schema and data of a table.  It’s called the "Microsoft SQL Server Database Publishing Wizard 1.1" and you can download it here, http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en.

    Regards

    Stevo

  • Just wanted to plug the following: bcp.exe

    it will export all the data in any table or query you care to write, and much faster to import than a .sql file with 10 million INSERT statements.

    oh, btw, I am not the product manager for bcp.exe

    ---------------------------------------
    elsasoft.org

  • Now, there's a plug I can agree with... AND, if you take the time to study it in Books OnLine, you'll find that it's capable of doing such things as allow "good" lines in and saving "bad" lines in a separate file for reconciliation, can import/export flat files and delimited files, has a "format file" that you can use (very worth getting good at that), and is nasty fast in either direction.  The only thing faster for imports is BULK INSERT (can use the same format file) but that's because it can't write bad lines to an error file, etc.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 16 through 17 (of 17 total)

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