VistaDB 5
SQL Script

The upper SQL editing options only apply to the SQL Editor Window. They are shortcuts to enable extended functionality for the SQL Editor window.

The Generate Schema Deployment Script menu item prompts for a location and writes a SQL file with all of the objects in the current database (except CLR Procs).  This script can be used to recreate the entire schema in VistaDB or SQL Server.

The Export Schema as Scripts menu item prompts for a folder location to export the entire schema as individual files by object in a format optimized for managing schema through your preferred SCMS, such as git.

See Also