VistaDB 6
VistaDB / Tools User's Guide / Data Builder / Menu Commands / SQL Script / Data Builder - Generate Schema Deployment Script
In This Topic
    Data Builder - Generate Schema Deployment Script
    In This Topic

    The entire schema of a database (except CLR Procs) can be scripted out into a single file using the Generate Schema Deployment Script in Data Builder's SQL Script menu.  The generated script will work with SQL Server and VistaDB and will create all of the tables, indexes, foreign keys, functions, and stored procedures in the original schema. 

    Since the script will contain GO statements it should be executed in Data Builder or SSMS, not directly against an ADO.NET database connection.

    To create a reference copy of your database schema to store in your preferred SCMS it's recommended that you use the Data Builder - Export Schema as Scripts which creates a single file for each object in your database.  This is more amenable to reviewing changes between versions.

    See Also