SQL Server Compact/Mobile Resources - Webcasts, Papers, Analysis ... etc

Question

SQL Server Compact/Mobile Edition References:

    SQL Server Compact Edition ==> SELECT Happy FROM Everywhere

    SQL Server Mobile is now SQL Server Compact and is unrestricted everywhere.  

    Announcement by Paul Flesner: http://www.microsoft.com/sql/letter.mspx

    SQL Server Compact Product Home Page:
    http://www.microsoft.com/sql/editions/compact/default.mspx

    Home Page: http://www.microsoft.com/sql/editions/compact/default.mspx

    Books Online (BOL): http://msdn2.microsoft.com/en-us/library/ms173053(en-US,SQL.90).aspx

    C# ADO.NET Reference: 

              MSDN:  http://msdn2.microsoft.com/ec4st0e3(en-US,VS.80).aspx

              MSDN Wiki: http://msdnwiki.microsoft.com/en-us/mtpswiki/system.data.sqlserverce(VS.80).aspx

    Database Objects' Limits: http://msdn2.microsoft.com/en-us/library/ms172451.aspx

    Connectivity Tools for SQL Server Compact/Mobile Edition replication with SQL Server 2000/2005

    http://www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx

 

    Connectivity Tools for SQL Server Compact 3.5 replication with SQL Server 2005/2008

    http://blogs.msdn.com/sqlservercompact/archive/2007/12/19/connectivity-cross-version-compatibility-sql-server-compact-3-5.aspx

 

    Web Logs (BLOGs):

Team Blog: http://blogs.msdn.com/SqlServerCompact/

Steve Lasker's Web Log: http://blogs.msdn.com/stevelasker/

   

     Meet some of the minds behind SQL Server Compact Edition!

     http://channel9.msdn.com/Showpost.aspx?postid=218346

 

SQL Server Compact/Mobile Webcasts:

1) Title: Developing SQL Server 2005 Compact/Mobile Applications

    Speaker: Darren Shaffer, .NET Compact Framework MVP

    URL: http://msreadiness.com/WS_abstract.asp?eid=15003229

2) Title: SqlCeResultSet

    Speaker: Maarten Struys, MVP

    URL: http://msreadiness.com/WS_abstract.asp?eid=15003433

 

SQL Server Compact/Mobile Blogs & Papers:

 

1) NET Compact Framework 2.0 Data Access Performance

    [Analysis and Metrics for SqlCeResultSet, and SqlCeDataReader]

    URL: http://xman892.blogspot.com/2005/11/net-compact-framework-20-data-access_12.html

2) Merge Replication Hands on Lab (HOL):

        http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

 

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Server CE, Microsoft India (R&D) Pvt. Ltd.

Answer 1

This is helpful.

Thank you!

Answer 2

Helpful post. But the Webcast links are broken.

Answer 3

Flyhoward Ltd is pleased to announce the release of SDF Viewer PC software to create, view and edit SQL CE databases.

Features

• Runs on your Windows 2000, XP, Vista
• Works with both SQL Server CE Version 3.1 and 3.5 databases - Auto Detection of Database Version
• Scans attached Windows Mobile Device for Databases
• Copies Database Files to and from your Windows Mobile Device
• Opens SDF Database file on your PC
• Creates New SQL Server Compact Edition Databases
• View the Database and Index Structures
• Add and Delete Tables
• Add and Delete Data Columns
• Add and Delete Indexes
• Add Foreign Key Relationships
• Add, Modify and Delete Data from Tables
• View, Add and Change Image Columns
• Run SQL Queries on the Database
• Add, Change and Remove Database Passwords
• Compact and Repair Databases
• Upgrade Existing Databases from Version 3.1 to 3.5
• Export Tables to Excel XLS and XML formats
• Import Pictures into a Database

Answer 4

broken link:

Books Online (BOL): http://msdn2.microsoft.com/en-us/library/ms173053(en-US,SQL.90).aspx


/en-us/library/ms173053(en-US,SQL.90).aspx

---

Using VS 2008