SQL Script Generator releases

New 🎉

• n/a

Changed 😎

• Standardized branding and icons.
• Dependency updates.

Fixed 🐛

• n/a

New 🎉

• n/a

Changed 😎

• Dependency updates.

Fixed 🐛

• n/a

New 🎉

• Translated into 47 languages. It starts in your Windows language. You can change it any time from the File menu or the Language button on the connection window, and every open window changes at once. The command line tool follows your Windows language too, or use /Language:de.
• Now follows your Windows light or dark setting. Restart it after changing the Windows theme.
• A filter box above the list (press Ctrl+F; Esc clears it). Filter, then tick a folder to tick only the matches.
• Right-click menu for the object list: Check all shown, Uncheck all shown, Expand all and Collapse all.
• Remembered selections: your selection is saved for each server and database.
• You can now save configuration from the file menu allowing you to save and load your options and selections. They use the same file format as the command line tool, so you can set up in the app and run unattended. Password are omitted.
• New log folder can be opened from the help menu, which records problems that used to go unnoticed.

Changes 😎

• Installs without administrator rights: the installer installs just for you, and includes everything it needs, so .NET no longer has to be installed first.
• Faster scripting: scripting a database’s schema is about 8× faster.
• Settings are stored in a file in your AppData, not the registry
• Right-click menu replaces the “Check Selected” and “Uncheck Selected” buttons.
• Updated look: the app now uses standard Windows controls, so some controls look slightly different.
• Windows 10 or later is required.
• Errors now show a message and are written to the log, instead of failing silently.
• Example configuration YAML file has been rewritten with a comment on every setting.
• Clicking Cancel a second time while an operation is stopping makes the app stop waiting for it.

Fixes 🐛

• The “Script tables” setting is now remembered between runs.
• The command line option /Output: now works.
• The example configuration file now loads.

Major additions

• None this release.

Enhancements

• .Net bump from 4.5.1 to 4.8.

Bug fixes

• Added checking for administrative roles. Some schema components were being silently ignored.
• Resolved issue where scripting to a single file would only produce the schema script for a single object.
• Resolved issue scripting the data for tables that contain only primary key columns.

Major additions

• Data exports can now be split into multiple files for easier execution.
• All automation scripts are now YAML instead of json.
• Implemented set-based data operations for much faster merges.

Enhancements

• Data export memory foot print reduced by orders of magnitude.
• Exported data is now 10-times smaller than before.
• Added ability to include NOCOUNT on data scripts (defaulted to true).
• Added full support for HierarchyId.
• Added full support for all custom data types.
• Made IDENTITY_INSERT optional.

Bug fixes

• Fixed issue when database drop-down contains invalid database.
• Canceling a scripting operation is now quick.
• Resolved issues when foreign-keys contain circular references.

Major additions

• None this release.

Enhancements

• Added support for Time data type.

Bug fixes

• Resolved issue where output directory was not set when selecting a directory.

Major additions

• Added ability to modify existing views, procs, functions and triggers.
• Updated UI and added easier output options.
• Added async with cancel to database loading.

Enhancements

• Renamed example json so better reflect its purpose.
• Updated to latest SQL Management Objects.

Bug fixes

• Excluded computed columns from generation.