Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

A Look At SQL Server Compact Edition Expand / Collapse
Author
Message
Posted Thursday, May 31, 2007 11:06 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/3040.asp

.
Post #370373
Posted Monday, July 09, 2007 10:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 28, 2009 4:52 PM
Points: 17, Visits: 27

I'm interested in some of the questions raised about SQL Server Compact Edition, I've been using SQL Server Express edition to process a subset of data from our main dataware house server to the local desktop. 

However its not easy copy data (unlike previous versions which contained DTS - MSDE) , at the moment its a matter or creating a linked server and using SELECT/INSERT method, not a great way.

Plus the restricted 4Gbyte of data, thou this doesnt apply to tempdb (does this exist in SQL Server CE??), thou you can create several databases splitting the data into each database and then create a view joining all the required data as a way around this.

I do like the sound of SQL Server CE, great for those offline client applications.

 

 

 

 

Post #380148
Posted Monday, July 09, 2007 10:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 23, 2012 10:31 PM
Points: 6, Visits: 15
hi friends after reading this topic i search one topic which may give yr ans and some new feature of sql server Mobile edition ( search on microsoft)

Post #380150
Posted Monday, July 09, 2007 11:27 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

re: "does this exist in SQL Server CE??"

Hi Ron,

SQL Server CE does not allow splitting a database into multiple disk files. You can have only one database file per database.

Jacob



.
Post #380155
Posted Monday, July 09, 2007 11:45 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 28, 2009 4:52 PM
Points: 17, Visits: 27

oops, sorry I didnt explain. 

create 2-3 databases, e.g. DatabaseA, DatabaseB & DatabaseC.

partition the required data into 3 tables splitting the data equally into DatabaseA, DatabaseB & DatabaseC.  Create a View in DatabaseA which contains the tables created in DatabaseA, DatabaseB & DatabaseC.  This should solve the 4Gigabyte limit, a bit messy to say the least....bill remove that 4Gigabyte limit !!!

 

 

 

Post #380160
Posted Monday, July 09, 2007 11:55 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

Hi Ron,

that would not work with SQLCE.

It does not support views.



.
Post #380164
Posted Tuesday, July 10, 2007 1:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 04, 2010 4:50 AM
Points: 3, Visits: 11
The biggest downside to using SQL Server Compact Edition is that it does not allow the creation of stored procedures. This seems to be Access with a different name and the same problems. If MS was serious about making this a viable product it should have been able to create stored procedures.
Post #380188
Posted Tuesday, July 10, 2007 3:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523

One of the biggest difference between MS Access and SQLCE is that ACCESS is a standalone application and SQLCE is a set of IN-PROCESS dlls that will get embedded to your application. Further, it supports Mobile and Desktop platforms.

Regarding Stored procedures: Steve Lasker, Program Manager of SQLCE at Microsoft has a detailed explanation in his blog (http://blogs.msdn.com/stevelasker/archive/2007/05/14/empowering-your-users-with-reference-data-and-knowledge.aspx)

 

 



.
Post #380208
Posted Tuesday, July 10, 2007 6:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 07, 2013 11:44 AM
Points: 51, Visits: 40
Good article; looking forward to the answers to your ending questions. I really appreciate and see the potential for using it in the disconnected scenario.


Post #380266
Posted Tuesday, July 10, 2007 6:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 32,771, Visits: 14,935
I'll agree that stored procedures should be supported. Even if they need to be compiled in process and executed, they are important have building a n appplication, especially one that might need to scale to a larger version or even share some code.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #380269
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse