I m just tried out this tool, it can generate entire database (including SP, View and table etc) with data into a single file.
Here the link
Brief Description (from MS website)
The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts or directly to supporting hosting service providers.
Archive for April, 2008
SQL Server Database Publishing Wizard
Posted in MSSQL, tagged MSSQL on April 11, 2008 | Leave a Comment »
