Home Forums SQL Server 2008 T-SQL (SS2K8) How to script table data with either TSQL or Powershell? RE: How to script table data with either TSQL or Powershell?

  • A couple more ideas.

    1 - When I was doing Oracle work in a past life, the TOAD utility had the ability to turn a record set in a data grid to a bunch of SQL INSERT statements.

    This is definitely slower than BCP.

    2 - Use the import export utility, which is a wizard utility tool, to create and run a simple SSIS package. This uses bulk copy operation under the hood.

    Many other ways can be listed, but the import/export and bcp utilities come installed out of the box.

    John Miner
    Crafty DBA
    www.craftydba.com