Other options are available in
(Open Source Community) for schema purposes:
It's a console application, that works for both SQL 2000 and SQL 2005.
Creates one script file for each object. You can choose to script objects with bcp.exe and you also have the option of scriting extended properties if you want to.
This is a command line tool which exports both SQL Server 2000 and 2005 objects in a single or multiple scripts files in order to create a database.
It was also designed for revision control purposes.
This command line tool works for both SQL 2000 and SQL 2005 and has three modes of operation:
- Generate scripts for an existing database
- Synchronize between two pre-existing databases
- Take a set of scripts and update the schema of a target database to make it equivalent to those scripts.
You can also do your own script using SQL-DMO or SQL-SMO to response to your own specific needs.