I saw this tool posted on Scott's blog and I thought it was really cool. There is a new tool called the SQL Server Hosting Toolkit (currently in RC) that makes it really easy to move databases from a local server to a hosting server without having to do database backups. Basically it creates a SQL script that contains the schema for your tables, stored procedures, etc, AND queries to populate the tables with data. I think there have been tools out there to do this before, but this is free and makes it look pretty easy.
SQL Server Hosting Toolkit
Scott's Post on the Toolkit
Read the complete post at http://www.dotnettipoftheday.com/blog.aspx?id=335