Pocketpc Developer, SQL Server 2005 Mobile vs SQL Server Compact Edition 3.1

microsoft.public.pocketpc.developer - Resources for Pocket PC developers. Articles, questions and answers,libraries, ActiveX components, books and other information


Pocketpc Developer >> SQL Server 2005 Mobile vs SQL Server Compact Edition 3.1

by Sm9obnNvbg » Thu, 26 Nov 2009 23:07:02 GMT

Hi,

Is there any whitepaper or facts about SQL SErver Compact Edition 3.1 has
better performance than SQL SErver 2005 Mobile?

Currently I am using SQL Server 2005 Mobile and my database performance is
very very bad. I am looking for upgrading of db if performance is better.

Please advise before I make the upgrade.

Thanks

--
Johnson

Top

Pocketpc Developer >> SQL Server 2005 Mobile vs SQL Server Compact Edition 3.1

by Ginny Caughey » Mon, 30 Nov 2009 20:23:26 GMT


This looks like a useful article for you:
http://msdn.microsoft.com/en-us/library/dd938877.aspx

--

Ginny Caughey
Device Application Development MVP








Top
Similar Threads

1. SQL Server 2005 Compact Edition vs SQL Server 2005 Mobile Edition 

Just noticed that MS has released SQL Server 2005 Compact Edition. As I 
understand it this will replace SQL Server 2005 Mobile Edition. 

I want to know what are the diffences between the two. What I've picked up 
CE will be able to run both on PDA and PC. But are there any other stuff that 
changed?
If not, any reason why we should upgrade to CE since we're only using the 
database on PDAs?

2. Synchronising SQL Server 2005 Express & SQL Server Mobile - Pocketpc Developer

3. Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

4. SQL Server 2005 Compact Edition running on PC? - Pocketpc Developer

5. Using SQL Compact Edition 3.1 with visual studio 2005 

I'm trying to build a small program with VS 2005, and the Vista SDK headers, 
but am getting an error when I compile my stdafx.h.

1>c:\program files\microsoft sql server compact 
edition\v3.1\sdk\includes\ssceoledb30.h(16412) : error C2011: 
'IRowsetBookmark' : 'struct' type redefinition
1>        c:\program files\microsoft 
sdks\windows\v6.0\include\oledb.h(14134) : see declaration of 
'IRowsetBookmark'


I get this when add the following headers at the end of stdafx.h.

#include <oledb.h>
#include <oledberr.h>
#include <ssceoledb30.h>


The only way I've found to get rid of the problem is to add the following at 
the top of my stdafx.h:

#define __IRowsetBookmark_INTERFACE_DEFINED__
#define __IRowsetBookmark_FWD_DEFINED__

Is this really the best solution?

Anthony Wieser
Wieser Software Ltd

6. Any difference between sql mobile 2008 and sql server compact edit - Pocketpc Developer

7. adding records from SQL Server Mobile to SQL Server 

Hi,

Im going to write a simple application (vb .NET) for mobile device (Windows 
mobile 2003). The program will add some records to a table (called tbl1) on a 
"SQL Server 2005 Mobile".  What I want to do is to put the mobile device to a 
dock connecting to a PC and somehow add (append) these records to a table 
(tbl1) on a SQL Server 2000 on a server which is on the same network with the 
PC. Probably the PC must have SQL Server client on, right; . So can someone 
tell me what I need to do in order to add these records;

Thank you, 
Kostas

8. Sql Compact 3.1 desktop and Sql Compact 3.5 desktop on the same PC - SQL Server CE