Sql Server - Generate Scripts

  • Hi Team,

    i want to generate Table with Data Scripts with Tasks > Generate Scritps,

    but i dont to all the records, i want only few records scripts based on condition..

    how to generate, Please suggest...

  • The tool generates all the data found in the table, so it's all or nothing.

    Maybe you can create a duplicate table and insert into that table only the data that you want and then generate the scripts.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Minnu (7/15/2013)


    Hi Team,

    i want to generate Table with Data Scripts with Tasks > Generate Scritps,

    but i dont to all the records, i want only few records scripts based on condition..

    how to generate, Please suggest...

    Use Tasks|Generate Scripts to create your 'CREATE TABLE' script WITHOUT data (or just right-click on the target table and 'SCRIPT TABLE AS...' Then use Tasks|Export Data which will let you enter a query based on your required filters to populate the new table as needed.

     

Viewing 3 posts - 1 through 2 (of 2 total)

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