You must Sign In to post a response.
  • Category: SQL Server

    Need to take a copy of my database objects schema(views,tables,triggers,procedures)

    i need to take a copy of my database objects schema(views,tables,triggers,procedures) into my PC.

    When i used the option "generate scripts" in sql 2005, All the create scripts are in a single file.But i need it in the seperate files.

    For ex if i am having 100 tables then i need to take the schema of these 100 tables in 100 files.

    Please guide me.
  • #746967
    [Response removed by Admin. Read forum policies.]

    Delete Attachment

  • #746970
    Is this option in SQL 2005??

  • #746972
    Yes this is available in SQL Server 2005.
    Let me know if you have any issues.

  • #746973
    Is this option in SQL 2005??

  • #746974
    i could not see this option..can you please guide how to get this option

  • #746975
    what is you SQL Server Service pack?

  • #746976
    i could not see this option..can you please guide how to get this option

  • #746977
    SP2

  • #746978
    SQL Server 2005 SP2 updates the generate script feature and gives you the option of generating separate script for each database object.

    Refer the attached screen shot for details

    Delete Attachment

  • #746979
    SP2

  • #746980
    Hi Nithya,
    Its not possible to take script for 100 tables in separate files in single stroke.

    Regards
    Poorna Kumar
    9629718324

  • #746981
    Please refer my scrren shot..i could not see the option

    untitled.bmp

    Delete Attachment

  • #746982
    Hi Nithya,
    Its not possible to take script for 100 tables in separate files in single stroke in sql server 2005.

    Regards
    Poorna Kumar
    9629718324

  • #746983
    Go thorough the attached file and below link

    http://earljon.wordpress.com/2008/04/10/sql-server-2005-scripting-each-objects-to-a-separate-file/

    WhatsNewSQL2005SP2.htm

    Delete Attachment

  • #746984
    I think you are using service pack 1. This feature is not available in SP1. Upgrade your SSMS from SP1 to SP2

  • #746985
    Please refer my scrren shot..i could not see the option

    untitled.bmp

    Delete Attachment

  • #746986
    Check your service pack version

    Regards
    Siva
    9500065709

  • #746987
    Please refer my scrren shot..i could not see the option

    untitled.bmp

    Delete Attachment

  • #746988
    Please check your SQL Server service pack version.
    Execute below script into your query window and check service pack version and
    let me know

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

  • #746989
    Please refer my scrren shot..i could not see the option

    untitled.bmp

    Delete Attachment

  • #746990
    Mine is SP3.Please refer the attached screenshot

    untitled.bmp

    Delete Attachment

  • #746991
    Please go through the below links
    http://blog.namwarrizvi.com/?p=109
    http://earljon.wordpress.com/2008/04/10/sql-server-2005-scripting-each-objects-to-a-separate-file/


  • Sign In to post your comments