When starting off (prototyping) an Umbraco project, it is becoming common to use SQL Server Compact (SQLCE) as your default database option. Depending on the size and scale of the website, you may find that you need to migrate your data over to full SQL Server (2005+).
There are many tools that you can use to migrate from SQLCE to full SQL Server, including WebMatrix and SQL Server Compact Toolbox (a Visual Studio add-on). While these tools are very good at what they do, they add an additional step and can often fail. (Mostly WebMatrix fails with unspecified errors).
To stay within the comfort of your Umbraco (v4.6+) back-office, this simple package adds a dashboard control to the Developer section, enabling you to script schema and data from a SQLCE database to a .sql file.