General information
Forum:
Palm, Pocket PC and Handheld
Category:
Pocket PC in general
You can also add:
Faster
Relational (In CEDB, you can have 2 records in the same table with completly different fields)
Also note that CEDB does support stored procedures, triggers and rules neither.
Morale of this story: Don't use CEDB unless you have a very small application with very little data.
>I thought I would forward the research on the benefits of SQL2000 CE versus CEDB files.
>
>Here is the benefits I have uncovered so far for using Microsoft SQL Server for CE:
>
>An upwardly compatible SQL grammar with SQL Server 2000
>
>Data Types Data Type Data Types: TinyINT, SmallINT, Integer, BigInt, Real, Numeric, float, bit, binary, varbinary, image, unicode character types, Money, datetime,uniqueidentifier
>
>32 indexes per table WOW!
>
>Null support
>
>Nested transactions
>128 bit file encryption built in
>
>DDL (Data Definition Language)support: create databases, create and alter tables, referential integrity, default values
>
>DML (Data Manipulation Language) Support: Insert, update, delete
>
>SELECT functionality includes YEAH YEAH YEAH - SET(aggregate) functions, INNER/OUTER JOIN, subselect, GROUP BY/HAVING YEA BABY!!!!!
>
>Scrollable and forward-only cursors
>
>Remote Data Access (RDA) to SQL Server 6.5 or higher
>
>Merge Replication with SQL SErver 2000
>
>WHAT IT DOES NOT HAVE:
>
>NO stored procedures
>NO triggers
>NO rules
>
>AND LAST BUT NOT LEAST Rudimentary tools for managing databases but from what I have read it, with !!!!!"A FOOTPRINT OF 1MB"!!!!, it provides a million miles of functionality and performance over Windows CE property (CEDB) databases.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only