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

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

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 (https://blog.sqlauthority.com)

Quest

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio
Previous Post
SQLAuthority Guest Post – Lessons from Life – Practice Let Go – Srini Chandra (Author of 3 Lives, in search of bliss)
Next Post
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2

Related Posts

22 Comments. Leave new

Leave a Reply