SQL Script Generator
Generate dependency-ordered scripts for any SQL Server object, with or without data.
Generate schema or data for any object
Simply put, the Vroom SQL Script Generator generates schema and data scripts from a SQL Server database. Beauty is in flexibility: script all tables to individual files with or without their indexes, all stored procedures to a single script, and all the data of a schema to a folder of insert and update statements, in one pass.
The scripts are always kept in dependency order, so they run in the order they are generated.
Automation
Make selections and save the project, then you can use the bundled command-line tool to generate the same snapshots - or just hand edit the yaml/json. This makes it a great fit for deployment packages, installers and continuous integration.
Simple to use
Connect to a SQL Server, select a database, check the objects you want and press Generate.
Three Modes
In export schema mode the objects you select are scripted as schema; in export data mode they are scripted as data. The modes keep track of their own selections, so selecting 5 objects for schema and 3 for data gives you 8 scripts.
User interface
The interface is available in 47 languages and follows Windows light/dark mode.
Screenshots
Download
What's new in v2.0.2
New 🎉
- n/a
Changed 😎
- Standardized branding and icons.
- Dependency updates.
Fixed 🐛
- n/a