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:
- Create Script to Copy Database Schema and All The Objects
- Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
- Copy Database from Instance to Another Instance – Copy Paste in SQL Server
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)