SQL Server has a notable lack of the ability to easily backup a database's schema - without the data. In response, I present SQLSchemaBackup. This small utility can be used to backup the schema of some or all of the databases on one or more servers simultaneously using multiple threads. The backup is accomplished using SMO (SQL Management Objects) so that the generated scripts adhere to SSMS standards.
Supports: - Custom types
- Databases options
- Functions
- Indexes
- Procedure
- Roles
- Rules
- Schemas
- Statistics
- Triggers
- Tables
- Users
- Views
|