Tuesday, March 22, 2011

SQL SERVER - Create Script to Copy full Database including SP, Trigger,Views ,function & all

How t0 take copy of database including all objects///////

here is the solution

Step 1 : Start

Step 2 : Welcome Screen

Step 3 : Select One or Multiple Database
If Script all objects in the selected database checkbox is not selected it will give options to selected individual objects on respective screen. (e.g. Stored Procedure, Triggers and all other object will have their own screen where they can be selected)

Step 4 : Select database options

Step 5 : Select output option

Step 6 : Review Summary

Step 7 : Observe script generation process

Step 8 : Database object script generation completed in new query window

No comments:

Post a Comment