12 votes

This package is marked as retired

This package was designed to work with Umbraco v4 to v6 only. Due to other package commitments, I am no longer maintaining this package.

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 15836 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
Version 8.18.x (untested)

You must login before you can report on package compatibility.

Previously reported to work on versions: 7.2.x, 7.0.x

Package Information

  • Package owner: Lee Kelleher
  • Contributors: Rich Green
  • Created: 31/05/2012
  • Current version 2.0.2
  • .NET version 4.0
  • License MIT
  • Downloads on Our: 4.6K

External resources