Here's a tool that completely slipped by me. I've been using ApexSQL for generation of SQL scripts for creating schema and data.
Turns out, during the Visual Studio 2008 installation I see "SQL Publishing Wizard" pop up on the list.
This tool, can extract schema and data and create a SQL script.
Download details: SQL Server Database Publishing Wizard 1.1