The problem:

Post-PHP developers always ask me about this. Because there are good know solution for MySQL in phpMyAdmin, but not so know for MS SQL Express. Usually, we are talking about ASP.NET, and we can easily decide what DB to use. MySQL very good database too and I'm often use it for web projects. 

While developing ASP.NET projects using SQL Express 2005 Database everything is good until you need move your database on server. Usually the best to create install script, but how to dump database schema and data ? For web developers, who just started ASP.NET development... or used MSDE before this can be a big problem.

The solution: 

The first way to publish everybody tries - DTS wizard... But there are no DTS wizard in SQL Express 2005.

The second way we can find over internet - some "strange" Export/Import functions in SQL Management Studio. So, after long search how to add these functions to Management Studio - no results.

And the right way. Appears, that Microsoft created  Microsoft SQL Server Database Publishing Wizard 1.1 that solves all the problems. Neat! It works with  Visual Studio 2005 and/or Visual Web Developer 2005.

Summary: 

So, what we need to develop project for ASP.NET 2.0:

1. Visual Web Developer 2005

2. Microsoft SQL Express 2005

3. Database Publishing Wizard

4. ASP.NET 2.0 Hosting