Generate a Database Installation Script for SQL Server – schema AND data

This could potentially be a really useful technique for certain kinds of deployment or migration tasks. The article describes a procedure to easily produce scripts to create your database schema and then populate the new schema with the data in your source database.

The article is here