Comments on Anything and Everything IT: SQL Server Compact Edition Multi-User Access

Hi Jeff,I have actually done a project which invol...

2007-11-09T23:06:00.000+11:00

Hi Jeff,
I have actually done a project which involved a web service for providing zipped initial sync sdf files to merge subscribers, basically building the sdf file on the server on-demand from the Pocket PC app. We got some interesting (ie good) performance benefits from this approach

Hi Christopher,This is something that I'm going to...

2007-10-31T09:36:00.000+11:00

Hi Christopher,

This is something that I'm going to start playing around with as the whole idea of creating SDF's on the server for easy download to PDA's is great. Also like how you're using it to provide users with a snapshot of a masters database. perfect for analysis and read-only data and so much easier to setup than merge replication.

Thanks for your comments.

Cheers
Jeff

I'm not so sure about using it as the backend of a...

2007-10-31T08:42:00.000+11:00

I'm not so sure about using it as the backend of a ASP.NET application, but I have used SQL Server Compact Edition within the ASP.NET environment before.

In one project we utilised it within ASP.NET to build slightly customised SDF files for eventual download and use on a PDA.

The website was basically used to data mine a SQL Server 2005 database, with the option to download a SDF file for use on a PDA etc once the nesscary data was obtained.

This involved using the 'trick' mentioned by Nick Randolph in order to get SSCE working within the ASP.NET environment. As Nick's article said:

"As Steve points out the scenario that this was originally added for was building sdf files (ie SQL Server CE database files) on the server side before being shipped out to the device."