March 27th, 2008 Posted in SQL Server | 1 Comment »
How do you backup your database schema and all the related objects? You can take a look at this post entry to learn more about it. The tutorial will guide you step-by-step to backup your database schema using SQL Server Management Studio. At the end of the tutorial, you will create a SQL script to copy the complete database schema and all the related objects, including Stored Procedure, Functions, Triggers, Tables, Views, Constraints etc.
Before starting your backup, you can download SQL Server Management Studio Express from Microsoft. It can be used for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.
SQL Server Management Studio Express:
Overview
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.
Note: SSMSE cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.
System Requirements
- Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2
- Computer with Intel or compatible Pentium III 600 MHz or faster processor (1 GHz or faster is recommended.)
- Minimum of 192 MB of RAM (512 MB or more is recommended.)
- 100 MB of available hard disk space
Warning: You must remove any beta or Community Technology Preview (CTP) versions of SQL Server Management Studio Express from your system before installing this package. Not doing so will cause installation of this package to fail.
More Details Here.