SqlScriptGenerator is the most straightforward tool to automate the script generation of SQL Server database of any edition (except non-supported SQL Server 2000). Below you can find what SQL objects and features are supported by SqlScriptGenerator.
Features:
-Database creation with its properties (collate, compatibility, fulltext indexes, ANSI padding, ANSI warnings, arithabort, Autoclose, auto create statistics, auto shrink, auto update statistics, set cursore close on commit, set cursor default, Concat null yields nulls, numeric round abort, quoted identifier, recursive triggers, broker, auto update statistics Async, date correlation optimization, trustworthy, allow snapshot isolation, parametrization, readonly, recovery, page verify, db changing)
-Database roles
-Database schemas
-Database users
-Database tables structure (tables with columns, their datatypes, identities, unique constraints, collation, persisted, not for replication, allow nulls, computed columns and computing expressions)
-Tables data
-Foreign keys and relations
-Table triggers