How to generate scripts for complete SQL Server database

by Jagadish Pulakhandam on 9/22/2011 1:35:16 PM
Rated 0 from 0 votes
Brief: Demonstrates on generating scripts automatically for entire SQL Server database (including data in table)
Posted to: Microsoft SQL Server - Quick Learn ("How to"s for Developers)
Add to DiggAdd to del.icio.usAdd to FURLAdd to RedditAdd to YahooAdd to BlinklistAdd to GoogleAdd to ma.gnoliaAdd to ShadowsAdd to Technorati

Attached video demonstrates the following:
  • Generate script (which contains all SQL commands for database objects) for entire database automatically using SQL Server Management Studio
  • Selecting various options while generating the script
  • Generating INSERT statements automatically for all tables in a database
  • Creating a new database and executing the script which was generated earlier (after executing the script, the new database should look almost identical to the previous database).


Join the .NET Code Central Community and join the discussion!
Signing-up is FREE and quick. Do it now, we want to hear your opinion
0

Rated 0 from 0 votes ( login  to rate)
DotnetKicks DotnetKicksDe DotNetShoutout


Video/Screen Recording (may not have audio narration/annotations)
You need to Login or Join for FREE to download the following