Skip to main content
SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects
Entry Date: Rate:
Site:
Keywords:
RSS Description:
Following quick tutorial demonstrates how to create T-SQL script to copy complete database schema and all of its objects such as Stored Procedure, Functions, Triggers, Tables, Views, Constraints etc. You can review your schema, backup for reference or use it to compare with previous backup.
Comments:

Ecellent tip if your server policies does not allow to upload a backup, you can just generate the whole DB script, including even data !!!