Post reply

how to take database. script with data not backup

  • June 13, 2012 at 5:02 pm

    #392514

    How can I take my database script(with data). Not backup

    please provide any information .

    Thanks

    dastagiri

  • June 13, 2012 at 8:24 pm

    #1500759

    If I'm understanding your question correctly, you can do this directly within SSMS:

    1. Right-click on your database in Object Explorer

    2. Click on Tasks -> Generate Scripts...

    3. Keep "Script entire database and all database objects" selected (click Next)

    4. Click on the Advanced button

    5. Towards the bottom of the "General" header, there's an option called "Types of data to script". Select the drop down and choose "Schema and data"

    Continue with the process to save the script to a file. If done correctly, you will have the aforementioned database schema and data in the script as a whole.


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • June 13, 2012 at 10:23 pm

    #1500778

    Use Generate Scripts option in SSMS

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

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