stevelasker

Visual Studio Orcas - Sync Designer, going N Tier with WCF

SteveLasker — Fri, 23 Mar 2007 02:33:00 GMT

In part 1, I used the Visual Studio Orcas Sync Designer to configure and synchronize 3 lookup tables to be cached locally in SQL Server Compact Edition using the Sync Services for ADO.NET CTP.

In part 2, I take the cached lookup tables and split up the client and server sync components using WCF to glue them together.
For more info about our Occasionally Connected Services scenarios, and Sync Services for ADO.NET, you can use the following links:
My blog
Sync Services CTP:
Sync Services Forum

Visual Studio Orcas Sync Designer for Caching Data in SQL Server Compact Edition

SteveLasker — Thu, 22 Mar 2007 00:26:00 GMT

In this screen cast I demonstrates the new Sync Designer for caching data locally in SQL Server Compact Edition. This is part 1 showing the basics. In part 2 I'll demonstrate how to split the code from client to server using WCF to synchronize data across internet protocols.

For more info about our Occasionally Connected Services scenarios, and Sync Services for ADO.NET, you can use the following links:
My blog
Sync Services CTP:
Sync Services Forum

ADO.net Programming options for SQL Server Everywhere

SteveLasker — Fri, 07 Jul 2006 00:05:06 GMT

A screencast overview of the different programming options for SQL Server Everywhere including an updateable resultset (SqlCeResultSet)

Steve

Deployment Options for SQL Server Everywhere

SteveLasker — Thu, 06 Jul 2006 23:58:37 GMT

Another screencast in the SQL Server Everywhere series demonstrating the deployment options for SQL Server Everywhere. In this screencast I talk about the Admin, Central, MSI deployment model with the assistance of ClickOnce bootstrappers as well as the private deployment model.

More info on SQL Server Everywhere can be found on my blog at:
http://blogs.msdn.com/SteveLasker
or the SQL Server Everywhere team blog a
http://blogs.msdn.com/SQLServerEverywhere

The CTP of SQL Server Everywhere can be found at:
http://www.Microsoft.com/SQL/Everywhere

Steve

Video of installing the SQL Server Compact Edition

SteveLasker — Thu, 06 Jul 2006 23:49:29 GMT

To get a feel for what it means to install the SQL Server Compact Edition here's a screencast that describes the installation experience and the minimal impact to your machine. This covers the download from: SQL Server 2005 Compact Edition CTP Download

The screencast also covers how to install the ClickOnce bootstrapper package within Visual Studio to cleanly enable deploying SQL Server Everywhere with ClickOnce.

For info on SQL Server Compact Edition, there's been a healthy discussion on my blog a

http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx

Steve