12 votes

Export SQL Server Compact

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.

This package makes use of the excellent SQL Compact data and schema script utility library by ErikEJ. #h5yr

Screenshots

Package owner

Lee Kelleher

Lee Kelleher

Lee has 14495 karma points

Package Compatibility

This package is compatible with the following versions as reported by community members who have downloaded this package:
Untested or doesn't work on Umbraco Cloud
8.0.x (untested)
7.14.x (untested)
7.13.x (untested)
7.12.x (untested)
7.11.x (untested)
7.10.x (untested)
7.9.x (untested)
7.8.x (untested)
7.7.x (untested)
7.6.x (untested)
7.5.x (0%)
7.4.x (untested)
7.3.x (untested)
7.2.x (100%)
7.1.x (untested)
7.0.x (100%)
6.1.x (100%)
6.0.x (100%)

You must login before you can report on package compatibility.

Package Information

  • Package owner: Lee Kelleher
  • Contributors: Rich Green
  • Created: 31/05/2012
  • Current version 2.0.2
  • License MIT
  • Downloads: 4989

External resources