SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video

The biggest request we keep on getting in SQL in Sixty Seconds is tricks with SQL Server Management Studio. It seems like SSMS is our favorite tool and we all want to share our neat tricks with everybody. Today I am going to share very popular and most requested SQL Server Tip. Sample data and test database is very common when working in a development environment. A developer often creates interesting samples as well challenging objects in their database. The architects work on databases and hand it over to developers, later developer hand it over to DBA. In simple words, in many cases the database move from one place to another place. It is not always possible to back up and restore databases. There are possibilities when only part of the database (with schema and data) has to be moved.

This often seems to be big challenge for many new developers and DBA. However, if you watch today’s SQL in Sixty Seconds you will find that it is very very easy to accomplish. I have previously written about this subject over here Create Script to Copy Database Schema and All The Objects.

More on Removing Debug Button in SSMS:

I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.

If we like your idea we promise to share with you educational material.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

13 thoughts on “SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video

  1. Hello!

    I’ve tried this way to generate the database scripts, but it’s not working quite properly. I’m always missing one specific table und quite half of my views in the script. I also changed some options to find a difference, but no success. Also create a script only for all tables or all views didn’t help. But when I just create a script with this wizzard for my missing table it works. The output says everything was ok.

    Is there something which can prevent the wizard to script the object? Is there another easy way to script all schema objects?

    Thanks for any advice!
    Kind regards!

  2. My thanks to you!

    Once again convinced that SQL Authority is the best site with SQL info and examples! Only here I FINALLY FOUND the method of exporting data to SQL file!!!!!!!!

  3. Could you use this to copy all data and schemas from SQL 2012 to SQL 2008r2 installation on a different server?

  4. Pingback: SQL SERVER – Weekly Series – Memory Lane – #038 | Journey to SQL Authority with Pinal Dave

  5. Hi Pinal,
    Thanks For all your help!
    Can you suggest a way to script or copy a maintenance plan without Integration Services?

    Thanks you,
    shani

  6. Pingback: SQL SERVER – Copy Database – SQL in Sixty Seconds #067 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s