Script SQL Server Database - Schema *and* Data
Good to see a CTP of a new publishing wizard for SQL Server appearing on the download site this morning. It can be used to generate the T-SQL scripts necessary to recreate a database with both schema and data. This could be very useful when you need to publish a database up to a hosted server environment. Details are at:
http://www.microsoft.com/downloads/details.aspx?familyid=16d8c1e9-a6a3-43a2-9ba7-916c6eb5023b&displaylang=en