none
How can i restore the full sql database script using command line ?

    Question

  • Dear Folks,

    How can i restore the full sql database script using command line ? SQL database script contains creation of database, users, tables, stored procedure and views.

     

    Thanks


    Sohaib Khan
    Wednesday, August 03, 2011 11:44 AM

Answers

  • You can do this with SQLCMD tool, here is help http://technet.microsoft.com/en-us/library/ms170572.aspx

     


    http://uk.linkedin.com/in/ramjaddu
    Wednesday, August 03, 2011 11:53 AM

All replies

  • You can do this with SQLCMD tool, here is help http://technet.microsoft.com/en-us/library/ms170572.aspx

     


    http://uk.linkedin.com/in/ramjaddu
    Wednesday, August 03, 2011 11:53 AM
  • Go into SSMS ( SQL Server Mangement Studio). expand the databases and select your database.

    Now right click on your database name and select tasks >> Generate Scripts....

     

    A wizard popups up which will guide you through the rest of the process.

     

    Surendra


    Nothing is Permanent... even Knowledge....
    My Blog
    Wednesday, August 03, 2011 12:15 PM