I need to script a database schema out to T-SQL for inclusion source control. The Express version of SSMS doesn't seem to let you script the entire database, just individual tables. Are there any free tools (scripts or otherwise) that can do this ?
Sql-server – SQL Server 2008 R2 Express Edition – generating database create script
schemascriptingsql-server-2008
Related Question
- Sql-server – Script all tables in a database
- SQL Server 2012 – How to Generate Scripts from Command Line
- SQL Server 2008 Deployment Script – Resolve Different Behaviors
- SQL Server – How to Get Object Script via T-SQL
- SQL Server Data Tools vs Liquibase and Flyway – Schema Migration Comparison
- Sql-server – Shrinking a SQL Server 2008 Standard database to move it into SQL Server 2014 Express
Best Answer
This SQL script is a SQL Server 2005 table scripting tool that I wrote to reverse engineer a database schema to SQL. It might do what you want. Load it in SSMS and set 'Results to Text' from the menu. Then run the script. It will reverse engineer most of the major database objects.