How to backup just the database schema, using LiteSpeed?
WORKAROUND:
Just a schema backup is not possible with LiteSpeed. While you can extract schema from a backup using OLR, you cannot selectively backup just the schema.
You can use Change Director for SQL Server for this type of activity. It contains a Snapshot facility that allows customers to schedule recurring or run ad-hoc database schema snapshots which are compressed and stored in a central repository. That, in addition to a comprehensive compare and sync framework with impact analysis and full logging of all schema changes by object, job scheduling, the log reader, and a change tracker component to watch the database for unplanned or unauthorized changes.
For additional info:
http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center