Post reply

TO GENERATE SCRIPTSTRUCTURE WITH DATA

  • July 29, 2008 at 4:40 am

    #382040

    hi

    I want to generate a script,should contains both the structure and the data existing in the database.Is ii available in sql server 2005

    thanks in advance

  • July 29, 2008 at 4:46 am

    #849674

    patr (7/29/2008)

    hi

    I want to generate a script,should contains both the structure and the data existing in the database.Is ii available in sql server 2005

    thanks in advance

    There are third party tools that can package a database for you. These can handle both the schema and the data, and have a variety of output formats.

    If you want to have the schema only, you can use SQL Server Management Studio in many cases. Just rightclick on the database in the Object Explorer, then Tasks -> Generata Scripts...

    You can later amend the generated scripts to include data.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

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

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