Access-like editor for SQL Compact Edition

views:

answers:

+1 Q:

Access-like editor for SQL Compact Edition

I'd like to find the best editor for flat SQL Server Compact edition databases. Essentially we want to push around arbitrary flat typed datasets of under 4 Gb each and have a good editing experience for manipulating this data. Access isn't the first thing that comes to mind, but I'm looking for a more "de facto" approach rather than the "road less travelled".

I'm looking for something I can point at a SDF file and have reasonably robust editing facilities for typed datasets, including multi-line ntext fields.

this seems to come fairly close, but it's not quite what I'm looking for (if I went down this route I'd look for something implemented in WPF), and I imagine somewhere, somehow, that this is a solved problem.

+1 A:

I have a list of 3rd party SQL Server Compact tools here: http://erikej.blogspot.com/2009/04/sql-compact-3rd-party-tools.html - Maybe one of those tools will do the job...

ErikEJ 2010-10-08 11:59:57

Hi Erik, your site was actually one of the first I referenced during my search. I didn't take a look at the commercial ones (I'm quite happy to pay for such a valuable tool!). I liked SQL Server Compact Toolbox (http://sqlcetoolbox.codeplex.com), especially for its support to script tables, etc, but WebMatrix was a *lot* faster when it came to rendering large data sets (albeit quite inflexible). I'm trying out Data Port Console now. I should probably also mention that I am focusing on SQL CE 4.0. PS: thanks for the extremely valuable resource. I'm sure your list has saved people many hours.

Solution Evangelist 2010-10-09 08:35:05

I am currently testing Data Port Console, the only commercial tool you have listed there that supports SQL CE 4.0, it looks very good. I'll update this Q if it covers all the bases!

Solution Evangelist 2010-10-09 09:08:33

I've ended up using a combination of Data Port Console and SQL Server Compact Edition Toolbox. Occasionally I am working with Microsoft Access 2010 (which I've largely avoided since Access 2000 and Classic ASP), and exporting to SQL Compact Edition via some handy LINQpad scripts.

Solution Evangelist 2010-10-28 08:03:52

ansaurus

tags:

views:

answers:

Access-like editor for SQL Compact Edition

related questions