Information about SQL Server Compact Edition (SQLce)

Syringe.Net.Nz - SQL Server Everywhere....

Syringe.Net.Nz - SQL Server Everywhere.... — Mon, 10 Apr 2006 07:17:24 GMT

PingBack from http://www.syringe.net.nz/PermaLink,guid,e3bae366-e108-4020-a746-2cb943c25d64.aspx

SQL Server Everywhere — всё проясняется... [Стив Ласкер]

Олег Михайлик — Mon, 10 Apr 2006 07:48:50 GMT

Стив опубликовал неплохой FAQ. Откуда произошёл SQL/e, отличия от большого SQL,

SQL goes wild everywhere

Nick Randolph's .NET Travels — Mon, 10 Apr 2006 08:04:39 GMT

Since the release of SQL Server 2005 late last year the mobile devices community have been discussing...

SQL Server Everywhere FAQ

Corrado's BLogs — Mon, 10 Apr 2006 10:03:43 GMT

SQL Server Everywhere FAQ

Corrado's BLogs — Mon, 10 Apr 2006 10:42:49 GMT

Information about SQL Server Everywhere

The Problem Solver — Mon, 10 Apr 2006 10:57:27 GMT

Steve Lasker posted a FAQ sheet on SQL Everywhere&nbsp; or SQL/e as he calls it. See http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx...

re: Information about SQL Server Everywhere (SQL Everywhere)

Maurice — Mon, 10 Apr 2006 10:58:21 GMT

http://msmvps.com/blogs/theproblemsolver/archive/2006/04/10/90219.aspx

Interesting things about SQL Server Everywhere

STEFANO DEMILIANI WeBlog — Mon, 10 Apr 2006 11:57:49 GMT

Hvad er SQL Server Everywhere?

guidmaster´s .NET blog — Mon, 10 Apr 2006 13:23:20 GMT

Steve Lasker har en del FAQ savr på hvad SQL Server Everywhere er: http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.asp...

SQL Everywhere and why I don't get it.

crucible's melting pot — Mon, 10 Apr 2006 14:28:24 GMT

Mabster put me onto a post Steve Lasker has made a post about SQL Everywhere&nbsp;and I gotta say, to...

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve Kass — Mon, 10 Apr 2006 15:53:56 GMT

You have referred to the new SKU several times as "SQL Everywhere". In a number of places on the Sybase, Inc. web site, it is stated that "SQL Everywhere" is a trademark of Sybase, Inc. or its subsidiaries. For example, see http://infocenter.sybase.com/help/topic/com.sybase.help.pb_10.5.apptech/html/apptech/legal.htm

Has Sybase, Inc. released their trademark on "SQL Everywhere" to Microsoft?

Steve Kass
Microsoft SQL Server MVP

SQL Everywhere FAQ

You Can Take it With You — Mon, 10 Apr 2006 16:25:15 GMT

Good news for smart client developers: SQL Server Everywhere

Ardent Dev — Mon, 10 Apr 2006 19:31:53 GMT

SQL Server Anywhere FAQs

Smartymobile — Mon, 10 Apr 2006 20:31:15 GMT

Steve Lasker&nbsp;ha escrito un excelente FAQ (inglés) acerca de de SQL Server Anywhere aquí.
&nbsp...

SQL Server Anywhere FAQs

wmugperu — Mon, 10 Apr 2006 20:31:19 GMT

Steve Lasker&nbsp;ha escrito un excelente FAQ (inglés) acerca de de SQL Server Anywhere aquí.
&nbsp;...

re: Information about SQL Server Everywhere (SQL Everywhere)

Xentrax — Mon, 10 Apr 2006 21:06:02 GMT

I'm happy! Perfect solution for storing user documents.

Information about SQL Server Everywhere (SQL Everywhere)

.NET Tools Blog — Mon, 10 Apr 2006 21:57:00 GMT

Informazioni su SQL Server Everywhere (SQL Everywhere)

.NET Tools Blog — Mon, 10 Apr 2006 21:57:21 GMT

The Lowdown on SQL Server Everywhere Edition

DonS.CF — Mon, 10 Apr 2006 23:02:35 GMT

On April 6th, 2006, Microsoft (via a SQL Server 2005 Update from Paul Flesner) announced a "new" product&nbsp;in...

SQL Server Everywhere

Antonio — Mon, 10 Apr 2006 23:10:57 GMT

re: Information about SQL Server Everywhere (SQL Everywhere)

The Flyer — Tue, 11 Apr 2006 09:04:48 GMT

Is it something like Firebird Embedded?

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Tue, 11 Apr 2006 16:36:48 GMT

I'm not familiar with the details of Firebird Embedded, so I can't make a comparison. To capture the essence: SQL/e is a lightweight, in-proc relational database that offers a subset of the data types and TSQL syntax to provide queries over relational stored data with transactional support. The SQL/e data format can be password protected with encryption. SQL/e is based on the proven history of the Microsoft SQL Server Mobile Edition technology.
For details on the feature list check out: http://www.microsoft.com/sql/editions/sqlmobile/default.mspx

Reporting Services Support
I added a Q&A about Reporting to the above content. Quick answer is YES.

There were some questions about how much SQL/e makes a difference with the LINQ project. SQL/e doesn't compete w/LINQ. SQL/e offers a better together story with LINQ. LINQ doesn’t have a query processor. It takes VB and C# syntax and composes a query to pass to the underlying store. The underlying store processes this query and returns a result to LINQ, or in this case DLINQ. In comparison, when using LINQ over XML, there’s no query processor involved. Large XML files wouldn’t compare in performance compared to leveraging a relational storage engine with a query processor. Remember, XML files would have to be fully loaded into memory to process a request. Relational databases have optimized indexes to only load the necessary information from disk into memory. So, for the scenarios where developers are using XML, or specifically DataSets persisted to disk as their local storage, SQL/e would provide data integrity with the transaction support, security, and a significant performance boost.

Steve

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Tue, 11 Apr 2006 16:53:03 GMT

Roger Wolter made a great post describing some of what we all went through in the VS Whidbedy product cycle. He gave a great summary of the market for SQL Server Express and SQL Server Everywhere: http://blogs.msdn.com/rogerwolterblog/archive/2006/04/09/572101.aspx
It's worth a read...
Steve

SQL Server Everywhere

It's my life... And I live it... — Tue, 11 Apr 2006 19:00:37 GMT

Interesting product
comparison between SQL Server Everywhere and SQL Server Express. Essentially...

Random Things

Sriram Krishnan — Tue, 11 Apr 2006 22:20:18 GMT

Hacked together a prototype for my Orcas feature over a weekend. Not bad for a PM,eh? :-). Sorry, I...

SQL Server Everywhere

Ancora Imparo — Wed, 12 Apr 2006 11:48:01 GMT

Steve Lasker posted a quick Q&amp;A on a semi-new version of SQL Server called SQL Everywhere....

re: Information about SQL Server Everywhere (SQL Everywhere)

Phylyp — Wed, 12 Apr 2006 12:40:35 GMT

Steve,
Forgive the newbie questions :)

Is SQL/e accessible/usable only through code, or will it have support for a GUI (SSMS-E or a similar one)?

Also, what are your views on using SQL/e rather than XML as a data store, for things like configuration, (BizTalk style) messages, etc.?

Phylyp

SQL Server Everywhere 追加情報(SQL MobileのWindows desktop 展開)

米田 Blog ( SQL Server MEMO ) — Wed, 12 Apr 2006 17:12:04 GMT

SQL Server Everywhere 追加情報(SQL MobileのWindows desktop 展開)

SQL Everywhere Q & A

OPC Diary — Thu, 13 Apr 2006 01:08:20 GMT

Steve Lasker's Web Log : Information abo...

re: Information about SQL Server Everywhere (SQL Everywhere)

Aaron A. Anderson — Thu, 13 Apr 2006 01:16:43 GMT

Why not just remove the usage restrictions of SQL Mobile in the interim? If it's good enough for Tablet PCs...

I understand you wanting to controll service pack and critical updates, but having a per app instance would also potentially eliminate a bug introduced with an update.

SQL Server Anywhere FAQs

Smartymobile — Thu, 13 Apr 2006 16:35:23 GMT

Steve Lasker&nbsp;ha escrito un excelente FAQ (inglés) acerca de de SQL Server Anywhere aquí.

re: Information about SQL Server Everywhere (SQL Everywhere)

Eric — Sat, 15 Apr 2006 17:24:34 GMT

How can we start developing with it now?
- Can we use Mobile for development while waiting for the CTP?
- Will our smart client prototypes work on XP if Mobile is used?
- How much will break between Mobile and SQL/e? If we put thousands of man hours with mobile (while waiting for SQL/e), we need to protect our investment.
- How reliable is the release date? We also have an "end of the year" committement date. There is some flexibility, but we need to control the risk level.

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Sun, 16 Apr 2006 20:59:47 GMT

Aaron,
This is exactly the type of conversations we're having. SQL/e doesn’t have the surface area that a server based product does, so we are less concerned about it. However, with the GDI+ bug, we’ve learned to never say never.
Since the api will remain the same, developers can get started today and we plan to hope have have a CTP of the install model by June 06.

Phylyp
SQL/e is accessable through the standard VS and SQL Server Management Studio editors. You can create databases, create tables, and in VS even edit data within those tables. In comparison to XML for configuration, SQL/e would be a great replacement. As configuration files get large, XML tends to become a problem. In order to read XML you have to load the entire document in memory to navigate to a particular node. Likewise, to save a single element, you have to read and save the entire document. With SQL/e you can read/write one row at a time so it will scale much better. While LINQ will make queering XML, Objects and Relational data easier, it leverages the underlying technology for query processing. So, LINQ doesn’t solve this problem for XML.
Also remember that SQL/e has security and encryption built in, so rather then having to take on the ownership of these problems when dealing with XML, you can delegate this to SQL/e.
One of the things we’re considering is providing a Windows Forms Settings Provider that would use SQL/e. We’re also looking to use SQL/e as the general cache for services on the client.

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Sun, 16 Apr 2006 21:12:21 GMT

Hi Eric,
Yes, yes, nothing, …

Something to recognize is that nothing is done until the software is in hand. So, while we aren’t planning any changes to the runtime, dlls names, or scenarios beyond what I’ve listed in the Q&A, it’s really hard to commit to anything further. If I said its firm and something comes up, what recourse is there? We don’t know what we don’t know.

Based on the current installed based on Win32 we’re very comfortable with its stability and complete feature set. We haven’t done anything in web environments and that’s not its target scenario so as long as you don’t assume this will work you’re on the safe line. The thing holding us up is the install model. Will Microsoft allow SQL/e to be installed by simply copying the dlls to your project as we do with SQL Mobile and Tablet PC? Or will Microsoft require an MSI to install the product. As with my previous post, we’re very comfortable with the security aspects, but we’ve also learned to never say never. If we allow developers to deploy the dlls directly, Microsoft has no way to directly service those dlls in the event of a critical security servicing issue. The problem is we don’t currently have a model that allows us to MSI install managed code without requiring Admin rights. We consider this a big issue for enterprise developers. What do you think?

Steve

Info about SQL Server Everywhere

Guy Barrette — Tue, 18 Apr 2006 02:50:54 GMT

From Steve Lasker's blog:http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx...

re: Information about SQL Server Everywhere (SQL Everywhere)

Brett — Tue, 18 Apr 2006 05:38:56 GMT

This is fantastic news to developers that use XML to transfer data back and forth to mobile devices like myself. If its only going to be available as an MSI package please don't limit the desktop install to XP SP2 as I find most large organisations (government mostly) still only have XP SP1 and in some cases 2000 SP4 and being a small development firm if we tell them they need to upgrade their OS to use our software their IT department’s would tell us to take a flying leap.

re: Information about SQL Server Everywhere (SQL Everywhere)

Eric — Tue, 18 Apr 2006 17:41:06 GMT

Steve,

My 2 cents: if I deploy a desktop application which uses SQL Everywhere, I will consider SQL/e a "component" of that application. If an upgrade is required I expect to do the same thing as with any other component: re-compile and re-deploy. Allowing to patch SQL/e on an existing application is scary since it does not change my build number. Support issues for sure.

I am extremely familiar with SQL Server, but SQL Mobile is totally new to me. Basically, I am trying to understand if:
a) the committement to the availability of that technology on the desktop is firm? If we invest a couple of millions in the next 6 to 8 months on this technology, I want to be on firm ground. I need to deploy in March 2007 at the latest, but probably a beta site in december 2006. Am I out of my mind?
b) While waiting for the summer CTP, can we start development with SQL Mobile? Is the desktop deployment restriction a license issue only? Or will it prevent developing and testing on XP?

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Wed, 19 Apr 2006 01:43:15 GMT

Hi Eric,
Thanks for the feedback on the deployment. We’re actively working on how we’re going to approach this balance. As we close on a decision, I’ll post it to this blog. I’ve opened another blog post related to the question: http://blogs.msdn.com/stevelasker/archive/2006/04/16/AdminInstalls.aspx

Yes, you can use SQL Mobile today. We are committed to releasing on the XP desktop. This is what Paul Flessner announced on April 6th: http://www.microsoft.com/sql/letter.mspx so your not out of your mind.

The Mobile Minute 137

Nino.Mobile — Wed, 19 Apr 2006 09:02:29 GMT

&nbsp;&nbsp;..just a few tonight as I get back in the groove. My new project kicked off this week here...

SQL Mobile goes Everywhere!

Zandoná Mobile® — Wed, 19 Apr 2006 16:11:45 GMT

For those (like me) who have missed this announcement, SQL Mobile is now called SQL Everywhere, and guess...

re: Information about SQL Server Everywhere (SQL Everywhere)

Rob — Fri, 21 Apr 2006 14:11:09 GMT

I would be benefitial if you provide SQL/E source code under a shared code license so as it could be ported onto other platforms as well. 1.4mb is not critical code that Microsoft can't help sharing or at least help porting onto other platforms.

Informaci

Blog de Antonio Soto — Sat, 22 Apr 2006 10:42:27 GMT

SQL Mobile on Desktop

SQL Mobile Blog — Mon, 01 May 2006 10:41:14 GMT

Hi and welcome to the SQL Mobile blog!
&nbsp;
The SQL Mobile team wants to make this blog a place...

re: Information about SQL Server Everywhere (SQL Everywhere)

Troy Wolbrink — Wed, 03 May 2006 20:54:51 GMT

I'm inspired by experiencing the Outlook 2003 model of seemless offline data access, and I'd love to implement this feature into my own applications.

My desktop application currently uses Jet 4.0 as the database backend. This has been ideal since my application typically only has one user connected to the database at a time. Jet's simple, inproc, single-file database engine has been great for my users.

But now I want to develop an ASP.NET version of my application as well as a CF.NET version. And I want these all to synchronize. For my ASP.NET app I’d be fine with using SQL Server 2005. For my CF.NET app I'd be fine with using SQL Mobile (Everywhere). But the engine to use for my desktop app has always been up for debate. SQL Server 2005 has dropped replication support for Jet/Access subscribers. SQL Express is just too much for my app or my users to download and maintain, and it's more of a 2-file system. Thus, I'm thrilled to hear about SQL Server Everywhere. I like that it is a strict subset of the full SQL Server, as I have a better chance of actually sharing some SQL code here and there.

However, from my perspective, there are some features I'd be losing with a transition from Jet/Access to SQL Server Everywhere:

1. Multi-user access to a database file on a shared network folder. I understand that this not a "best practice" for multi-user situations, but for non-technical users this provides a VERY simple solution for very small teams (ie. husband/wife on a home network). Perhaps the artificial limit could be raised to allow connections from no more than two computers at a time.

2. The query designer. I often use the visual query designer to more quickly write my SQL. From what I can tell this is not available in SSMS for SQL Mobile databases. It seems like this could easily be added to SSMS without touching the SQL Mobile engine. It would also be nice if it would provide the SQL script for creating tables, etc.

3. Ability to link to tables from Access. My application has many integration points with Office, and one such feature of my application generates a new Access database for my user with linked tables referring to my application's database tables. This gives my power-users a way to write their own queries and reports. From what I can tell, Access 2003 can not link to tables in a SQL Mobile database. Perhaps if an ODBC driver could be provided, this would be possible as Access could use ODBC for this.

These are not necessarily show stoppers, but they would be a step backward. I’m still strongly considering moving to SQL Everywhere. But if these three shortfalls could be addressed the choice would become more obvious to me.

Thanks,
Troy

SQL/e

yysun — Mon, 08 May 2006 23:41:06 GMT

TrackBack From:http://yysun.cnblogs.com/archive/0001/01/01/394478.html

re: Information about SQL Server Everywhere (SQL Everywhere)

Erik at HS — Tue, 16 May 2006 10:20:05 GMT

Re: Can I use SQL/e as my web server database?
A: No. SQL/e is targeted at the desktop database. Our plan is for SQL/e to throw a not-supported exception when the hosting process is IIS.

- we currently have a scenario where we prebuild device databases via a web service and would be very sad if we are no longer allowed to do so - any thoughts ?

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Thu, 18 May 2006 04:55:26 GMT

Troy,
Multi-User – The architecture limits our ability to make it multi-computer/user. Multiple users on the same computer can share the same database, even at the same time as each database instance has a shared memory footprint. However, the locking scheme prohibits us from enabling multi-computer. Jet does this with a lock file external to the database file that the engine knows to look for. This was the pro, and con for the stability issues as it’s really not a client/server database. It’s a file shared database suspect to network drops and corruption. So, I don’t see us doing multi-computer as this would be an architectural change and muddying the line between per user database/data and multi-user.
However, using the new sync components, our goal is to make it very trivial for you to keep your household in synch with a master database. And, yes, the master could actually be another SQL Ev database.

Query Designer/Builder – If your talking about the query builder that is shared in VS and SSMS then this should work. The Query Builder is actually built by VS and is shared in many products. There were some discrepancies in Whidbey that we’re working to rectify. For instance you can edit data in SQL Ev within Visual Studio. However, you can’t do this in SSMS. Some of this will be fixed in SSMS SP2.

Access / ODBC – Yup, this has been coming up a lot. We don’t know when / how we’ll enable this, but we are hearing it quite often. So, I’d like to say stay tuned, but honestly we have a lot of work to do in a short time to add a bunch of features to SQL Ev for the Orcas release. And, of course, we’re still working on the initial release of SQL Ev. We’re still on track for Tech Ed and I’ll post some details soon.

Erik,
Are you saying you already do this today? I’m assuming you either have VS or SQL Server installed on the same box. There are a couple of ways to solve this. One is to use a Windows Service to actually build the .sdf files. While we will be blocking ASP.net from using SQL Ev directly, it will be a soft block as we do know there are scenarios where developers have justifiable needs. Honestly, we haven’t yet decided how to message the work around. We’re really concerned about not creating the same IIS/Jet problems we’ve had in the past with frustrated users who start with Jet then don’t understand why it doesn’t scale.

Thanks for the great feedback Troy, Erik and others. The feedback posted has been helpful for me and the team to prioritize all the things we’d like to get done.

SQL Everywhere : SQL Mobile 2005 porté sur PC

Convergence numérique — Sun, 21 May 2006 14:26:37 GMT

Voici une très bonne nouvelle pour les développeurs de solutions mobiles : la base de données Sql Mobile...

re: Information about SQL Server Everywhere (SQL Everywhere)

Troy Wolbrink — Mon, 22 May 2006 23:29:43 GMT

> Multi-User – The architecture limits our ability...

I didn't realize this. I'm a *little* more satisfied knowing it's not artificial, but consider this a feature request (among many I'm sure).

> However, using the new sync components ... And, yes, the master could actually be another SQL Ev database.

This sounds *very* intriguing. I can't wait to hear more about it!

> Query Designer/Builder – If your talking about the query builder that is shared in VS and SSMS then this should work.

I tried the designer in VS and it worked much better. That's good enough for me!

> Access / ODBC – Yup, this has been coming up a lot. We don’t know when / how we’ll enable this...

Perhaps the Access team has/will enable this by adding support for linked tables via OLEDB or even ADO.NET drivers. Isn't ODBC a bit dated anyway? :^)

> While we will be blocking ASP.net from using SQL Ev directly, it will be a soft block as we do know there are scenarios where developers have justifiable needs.

Here's some ideas: Have an "un-block" registry key or something you can add to the web.config or machine.config. Perhaps even require a licensed SQL Server available, if losing sales is a concern.

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Tue, 23 May 2006 03:21:29 GMT

Access – We’re trying to figure out who’s going to support which side. Honestly, it’s a little low on our priority list for now, but something that will definitely move up the stack. The fact that Office and users would want to use SQL Ev for their scenarios means we’re right on target. I’m confident it will happen, just a matter of how fast.

IIS/ASP.net Unblocking – we do have an “unblock” mechanism. We just haven’t decided how to message it. We basically don’t test or immediately intend to support multi-user web scenarios, but developers have single user asp.net scenarios. Since there’s no way to differentiate these, we decided to “soft block”. Make your case, a gift would be nice, and we we’ll eventually make the key a little less secret. <g>
Steve

re: Information about SQL Server Everywhere (SQL Everywhere)

Erik at HS — Wed, 24 May 2006 16:56:24 GMT

IIS/ASP.net Unblocking - our case is that we currently have in production a mechanism to build SQL Mobile files server side for performance reasons. Hope that is specific enough...

re: Information about SQL Server Everywhere (SQL Everywhere)

Lonifasiko — Thu, 25 May 2006 09:03:11 GMT

Hi,

I would like to know if we, Compact Framework programmers would be able to synchronize with SQL Server Anywhere using RDA or Merge Replication freely.

What's the expected launch date for SQL Server Anywhere?

Thanks in advance.

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Sat, 27 May 2006 19:37:12 GMT

Lonifasiko
We're finalizing the dates for the launch date, but we'll have a CTP ready at Tech Ed. Final date is broadly stated as 2nd half of 06 as we want to leave a window open for feedback for releasing the bits.
SQL Server Everywhere replaces SQL Mobile. So, what ever you could do with SQL Mobile ont he device, you can do with SQL Everywhere including merge replication and of course RDA.
What I think your question is, is whether SQL/e can be a publisher. The answer is no for RDA and Merge. But it can for our future sync components we'll be shipping in Orcas. So, you'll be able to sync from SQL/e on the device to SQL/e on the desktop.
Did I get your question correct?
Steve

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Sat, 27 May 2006 19:39:18 GMT

Erik, pleaes contact me directly: http://blogs.msdn.com/stevelasker/contact.aspx

re: Information about SQL Server Everywhere (SQL Everywhere)

Jeff Bowman — Sun, 28 May 2006 12:13:42 GMT

Regarding redistribution rights, will licensing for small-footprint ISV retail applications built on SQL/e be royalty-free?

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Mon, 29 May 2006 06:28:57 GMT

Hi Jeff,
SQL/e is free for one, two or two thousand copies. Of course, if you want to pay us, I'm sure we can arrange something <g>.
To be complete, SQL/e doesn't have any licensing fees. However, SQL Server does. So, if you're using SQL/e to sync with SQL Server, that's when you'll need a client access license CAL for each client synching. SQL Server just considers this another connection, so it doesn't matter if it's SQL/e, a web client or a smart client, they're all just clients.

Steve

Catching up.

crucible's melting pot — Mon, 29 May 2006 12:16:44 GMT

Hey,
I know I don't blog much so heres a few things that you probably saw if you read my comments, but...

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve Clark — Tue, 30 May 2006 22:55:20 GMT

Just ran across your info about SQL/e and was excited to here about an alternative to Access and SQL/x. We currently use Access in our VB6 application. However, many of customers share the .mdb accross a network, which, if I'm reading correctly, SQL/e would not support. We're not thrilled at the prospect of installing and running SQL/x on each of their desktops.

I'm not sure I understand your statement:
"We are working hard to make sure we don’t paint ourselves, or allow developers to paint themselves into a corner and travel down a dead end path."

I would love to have "corner" that included SQL/e that could access the database file over a shared network folder.

Any new SQL/e developments in this area?

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Wed, 31 May 2006 15:10:47 GMT

Hi Steve,
The problem is SQL/e is designed and optimized as an in-proc, multiple connection, lightweight database. It’s not a client/server, multi-user database service that knows how to remotely service requests. Jet does enabled users to share mdb’s across the network, and while it has been productive, it’s also been one of the biggest source of problems. Rather then taking the one-size-fits-all approach, with the release of SQL/e we are working to divide and conquer the local in-proc database scenario and the multi-user client server database.

Considering the footprint, absolute minimal impact to your desktop machines, I’m curious why you’re not thrilled about installing SQL/e on each machine. Even if we supported shared .sdf files on a network share, we would still require SQL/e to be installed on each machine. That’s the nature of an in-proc engine. This is the same for Jet.

It’s worth noting that while we don’t support, and don’t intend to support, -shared- .sdf files on a network share, you can place the .sdf on a file share for single user usage. The first machine that opens the .sdf file will gain a lock that will block other machines from opening the file. This enables users who share their personal documents on a file share.

Steve

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve Clark — Wed, 31 May 2006 20:08:36 GMT

Steve,
I think you misread my statement: We're not thrilled about installing SQL Express on each of our customer's desktops. We may end up doing it if we have to. Many of customers have a small number of workstations networked together with one acting as a server in the sense that it shares folders and files. In this environnment, it seems a bit much to install and run a service on each desktop to access a common data file. But I might be mistaken here :-)

The sync features sound interesting. Are they available now? Could you have SQL/e equipped workstations syncing to another SQL/e equipped workstation sharing the .sdf?

Thanks,
Steve

re: Information about SQL Server Everywhere (SQL Everywhere)

Steve.Lasker — Sun, 04 Jun 2006 04:34:13 GMT

Steve, I think your getting SQL Express and SQL Everywhere confused. You’re not the first; we trip up in meetings all the time <g>
SQL Everywhere doesn't run as a service. It's simply several dlls, totally less then 1.6mb. If you exclude the 227k ADO.net provider for SQL/e the entire SQL Everywhere runtime fits on a floppy.
When you install SQL Everywhere it simply copies these dlls to the %ProgramFiles%\Microsoft SQL Server Everywhere\v3.1 directory. It then GAC's the ADO.net provider so it can be loaded by managed apps. There's no service running, EVER. If you're not using SQL/e as part of your app, it isn't running. It can't run as it can only run if it's loaded in-proc by an application.
So, the impact of installing SQL Everywhere is about as minimal as it gets.

Now, for your small networks where you want several desktops to share a common database, then yes, that’s the SQL Express scenario. You would install SQL Express on that one, and only one workstation. Each client can connect to that single workstation. In this case you likely wouldn’t have a local database on each machine as they’re all sharing the common SQL Express.

SQL Express is the free Data as a Service platform. SQL Everywhere is the single user data storage solution.

New sync features. We don’t have anything released yet. I’ll have some stuff to demo at Tech Ed, but nothing to share just yet. Yes, you’ll be able to sync between SQL Everywhere and a central SQL Everywhere database. In this case SQL Everywhere still isn’t being exposed as a service, rather you would configure your machine to expose Sync Services that would then load SQL Everywhere. While this is possible for some scenarios, our mainline scenario is to use SQL Everywhere on the client and sync with SQL Server (Express, standard, pro, …)

Now, just to fill in one more scenario, you can open an .sdf from a file share. However, the first machine that opens the file places a lock on it, and no other machine can open the file until the first closed the connection, thus releasing the lock. Because SQL Everywhere runs in-proc, the hosting machine literally opens the file and does the locking behavior. Jet has a lock file they place on disk, which while empowering has all sorts of issues.

Hope this helps,
Steve

MEDC 2006 Europe Keynote - DONE!

Backstage at MEDC — Tue, 06 Jun 2006 17:49:05 GMT

Another fantastic event kicked off in Nice, France today at the Acropolis.
Todd Warren delivered a...

Tools & Help For Building Mobile LOB Applications

Windows Mobile Sync and Replication Platform — Fri, 09 Jun 2006 01:50:24 GMT

If you're developing Line-of-Business (LOB) applications that have needs beyond the cool stuff provided...

SQL Server 2005 Everywhere Edition - lightweight, flexible, free datastore

Robert Burke's Weblog — Tue, 13 Jun 2006 12:25:28 GMT

SQL Server 2005's Express Edition is free, it supports database sizes up to 4GB, it allows seamless upgrades...

TechEd에서 발표된 것들

bkchung's WebLog — Wed, 14 Jun 2006 06:37:57 GMT

VSTE4DP(Visual Studio Team Edition for Database Professionals) - 얼마전에 발표한 VSTE4DP의 CTP.
Biztalk Server...

re: Information about SQL Server Everywhere (SQL Everywhere)

Diego Vega — Wed, 14 Jun 2006 22:47:44 GMT

Steve, when you say "Our plan is for SQL/e to throw a not-supported exception when the hosting process is IIS", there is an issue that comes to my mind. Right now we are working on an application that needs to run on the web in multiuser mode, but also needs to run stand alone in disconnected scenarios. Because of costs concerns we decided that we would only develop a ASP.NET 2.0 version of the application and then would leverage this same version on local IIS for stand alone mode. I see that such an scenario would not be supported by SQL/e. But in any case, don't you think it would be interesting to pair SQL/e with Casini? I think this would be an interesting lightweight duo.

New and Notable 101

Sam Gentile — Thu, 15 Jun 2006 01:06:14 GMT

Not much today.
WCF/SOA/WSE

The WCF RSS Toolkit is a Windows Communication Foundation-based framework...

CTP of SQL Server 2005 Everywhere Edition Now Available

Backstage at MEDC — Thu, 15 Jun 2006 07:17:46 GMT

SQL Server 2005 Everywhere Edition is the&nbsp;followup to&nbsp;SQL Server 2005 Mobile Edition (SQL Mobile).&nbsp;&nbsp;...

Information about SQL Server Everywhere (SQL Everywhere)

StWy — Fri, 16 Jun 2006 16:02:18 GMT

How can we access the Sql everywhere from the management studio?

The only servers I can get is localhost\SQLEXPRESS

re: Information about SQL Server Everywhere (SQL Everywhere)

matt.tester — Sat, 01 Jul 2006 11:28:45 GMT

It's a shame about the restriction with using it for ASP.NET applications. I can understand the reasons as they've been described but there is surely a case for Sql Everywhere being used for simple websites, where a full SQL Server hosting plan is overkill.

re: Information about SQL Server Everywhere (SQL Everywhere)

Phylyp — Mon, 03 Jul 2006 13:35:59 GMT

For what it's worth, I support your decision to not support multi-computer access to SQL/e databases.

I once built a Jet solution that was accessed by multiple computers, and watched it *sink* when about 50 users hit it.
I then had to introduce a connection-pool between the client and the database, basically turning a simple two-tier app into a three-tier one!

SQL Mobile on Desktop

SQL Server Everywhere Blog — Mon, 03 Jul 2006 16:10:20 GMT

Hi and welcome to the SQL Mobile blog!
&nbsp;
The SQL Mobile team wants to make this blog a place...

SQL/E Windows 2000 support

Marcin Kosieradzki — Thu, 06 Jul 2006 16:23:53 GMT

Hi,

Is SQL/E RTM going to support Windows 2000? CTP version supports only XP SP2+, but this post states that: "SQL/e will be enabled on all Win32 desktop platforms.".

ADO.NET and SQL Server Everywhere

Data Access blog — Fri, 07 Jul 2006 08:10:21 GMT

Steve Lasker has posted a screencast / video over on Channel 9 providing an overview on the various ADO.NET...

SQL Server Everywhere

Windows Forms Documentation Updates — Mon, 10 Jul 2006 20:22:30 GMT

Steve Lasker has a stream of information about this new technology. Start with his Info post and work...

ADO.NET and SQL Server Everywhere

ADO.NET team blog — Tue, 11 Jul 2006 20:39:02 GMT

(this post was originally posted here)
Steve Lasker has posted a screencast / video over on Channel...

re: Information about SQL Server Everywhere (SQL Ev, SQL/e)

acid — Thu, 20 Jul 2006 22:39:28 GMT

Is SQL/e support Windows XP Embedded OS?

SQL Server Everywhere (SQL Ev, SQL/e)

Hans — Mon, 24 Jul 2006 00:37:33 GMT

This is wonderful, highly appreciated stuff.
You encouraged us in the Channek 8 video to send requests for Xml support.
Yes: please do! Xml will be crucialfor a more object orientated use: With Xml support, code revision and maintenance of applications by others will be significantly enhanced.

Hans

re: Information about SQL Server Everywhere (SQL Ev, SQL/e)

crifo — Thu, 27 Jul 2006 17:53:04 GMT

Hi Steve,
I must to realize a database application for an Automation system consisting of a Industrial PC with Operative System microsoft windows embedded.

1° question: Is Microsoft sql server 2005 everywere compatible for Microsoft windows embedded?
(I ask this because in specific of its is not clear)

2° question: In the case that it's compatible, if I instal it in a industrial Pc can it to act by database server or necessity of a remote server?

What is 'SQL Server Everywhere Edition'?

Data — Fri, 28 Jul 2006 07:51:20 GMT

So, what is 'SQL Server Everywhere Edition'?
Answer?

Check out this Channel 9 video with Anil Nori...

SQL Everywhere FAQ

Jan Yeh — Wed, 02 Aug 2006 06:32:06 GMT

re: Information about SQL Server Everywhere Edition (SSEv)

Anthony Carrabino — Sun, 13 Aug 2006 12:07:02 GMT

With all this excitement about SQL Everywhere, i just wanted to post about another exciting database release for .NET and Compact Framework developers -- VistaDB 3.0.

We just released VistaDB 3.0 CTP, which unlike SQL Everywhere, is the world's first fully managed and typesafe SQL database engine designed for .NET and the Compact Framework. VistaDB 3.0 will run on fully managed on .NET, 64-bit .NET Compact Framework, Mono, and Windows Vista. Lots of features and interesting differences between VistaDB 3.0 and SQL Everywhere -- we hope .NET and Compact Framework developers take a serious look at what we built.

Comparison of VistaDB 3.0 vs SQL Server Everywhere:
http://www.vistadb.net/compare_sql_everywhere.asp

Screenshots:
http://www.vistadb.net/screenshots_vistadb3.asp

VistaDB 3.0 info:
http://www.vistadb.net/vistadb3.asp

Thanks for letting me post to your blog.

Anthony Carrabino
www.vistadb.net

Is SQL Everywhere really more secure than SQL Express?

Stew Davis — Thu, 17 Aug 2006 17:03:14 GMT

I understand your point about mdf file, but if the file is not encrypted in SQL Everywhere what would keep someone from reading the native file format and extracting the data. If they have the wherewithal to know to copy and attach the mdf file than it would be likely that they will know how to read an unencrpted SQL Everywhere file (via some download if they don't have the programming ability). Also, while the SQL Express service is running a user will not be able to copy the file. I assume this is not the case SQL Everywhere.
Is the above accurate?

What are the performance issues associated with encrypting the SQL Everywhere file?

How much of the SQL 2005 TSQL will be supported?

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Fri, 18 Aug 2006 06:29:00 GMT

Hi Stew,
Everywhere Edition files can be encrypted in two ways. One, you can simply encrypt the file on the connection string. If you don’t have the password, then you can’t parse the file. However, because securing a password is near impossible on the client, SSEv supports the features of the Windows Encrypted File System (EFS). With EFS enabled on a file, users are unable to copy the file off the machine if they aren’t the user. If they are the user, they are prompted that copying an EFS enabled file will loose its encryption. The main point about SSEv vs. SQL Express (SSE) encryption comparisons, is the features of SSE encryption are based on the typical server environment. Once you’re “on the box”, it’s relatively easy to circumvent the security features. SSE does support EFS when used with the User Instance features, but not under standard connection features. When running with User Instance, the service is running as the user, so it has the necessary rights to open the database as it’s encrypted as the same user as the service. This isn’t the case when the database is running under the main instance. When running with the User Instance feature, the database isn’t attached until the application is running. So, the rouge user can copy the file. Security is only useful if properly implemented. The more complex the model, the more likely it won’t be properly secured. The issue here is while SQL Server has some of the best security features in the industry, they are geared around server scenarios where you connect to the server remotely. SSEv was designed where the data file is always in the hands of the user.

Copying files
You can copy a SSEv data file while it’s open. This is actually the backup mechanism. However, as noted above, if using the User Instance Features of SSE, you can copy the MSF file if the app isn’t running.

Perf
We haven’t published perf numbers for SSEv yet as we’re still optimizing for desktop scenarios. This is one of the reasons we’ve been holding up the initial SSEv desktop release. However, with SSEv, we don’t consider TSQL throughput the top feature. We think of performance of the overall machine. However, with that said, we are making sure that SSEv performance numbers are very good.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Fri, 18 Aug 2006 06:35:30 GMT

Crifo,
Windows Embedded:
Like Win2k, we do believe we can support Windows Embedded. However, there are enough differences that the QA team wants to run some test passes before committing to it. So, the answer is, it should work, we would most likely fix any bugs, but we’re still finalizing how official we’ll be on Windows Embedded. …stay tuned.

Remote connections:
I’m not sure I understand the question, but I’ll answer it this way. Let me know if you meant something else. SSEv does not listen to network traffic. There is no hosting service. However, you can do one of a few things. You can write your own Windows Service to expose it. You can also connect to the file by sharing the file sharing.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

srinsoft — Mon, 21 Aug 2006 08:43:41 GMT

Hi
We are devloping a database management utility for MSDE,sql server enterprise and sql EV
There are system queries available for performing index rebuild and setting minimum and max memory on msde and sql server by using the following statements below
"DBCC DBREINDEXALL(S)"
"SP_configure 'min server memory',1024 Reconfigure"
"SP_configure 'max server memory',6144 Reconfigure"
But is there a way I can perform the same on SQL Ev. I tried using the above statements, but it doesn't wor out, can anyone help me with statements specific to SQL Mobile or Ev.

re: Information about SQL Server Everywhere Edition (SSEv)

JazzyJ — Wed, 30 Aug 2006 15:21:00 GMT

Is SSEv thread safe?

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Fri, 01 Sep 2006 06:45:36 GMT

Yes, SSEv, as an engine, is thread safe. Multiple processes, appdomains, apps, can all connect to the same SSEv data file at the same time.

re: Information about SQL Server Everywhere Edition (SSEv)

Shloma — Sun, 10 Sep 2006 21:05:29 GMT

Hi

The main problem for me is, that SQL Server Express is too big of a download and takes too long too install so I was hoping that the SSEv will help me here, but since it dosn't support sprocs, views and UDF's its a real problem for me, did anything change in this regard since you wrote this blog?

Regards,
Shloma

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 16 Sep 2006 08:01:10 GMT

Hi Shloma
No, we do not plan to support code in the database, which includes Sprocs and UDF's. Views are a bit interesting, but we believe the ADO.NET entity framework will provide the abstraction that views provide and more.
It takes folks some time to think about a local database differently. Simply put, when you have a database in-proc with your code, why would you limit yourself to the TSQL language. You can do a lot more with managed code than you can accomplish with TSQL. And, that assumes we have full SQL Server TSQL support. There's a reason the engine is so small, we have the focused features for an in-proc database.
What would you expect from sprocs? Abstraction? The database is part of your app? The typical abstraction layers required between the database and multiple apps just don't apply.
Performance? While we could sneak some performance for caching a query plan, we'd likely loose it for the extra "weight" of supporting sprocs?
UDF's? Again, what about using a function in full managed code? With LINQ, and the ADO.NET Entity Framework, we have a more powerful features at your hands. ...or you will...
Views? Aggregate multiple tables in a single view? Views typically only update one base table, ...sometimes. With the Entity Framework you can get the aggregation, and all tables are updateable.

We appreciate the need for wanting the same programming model locally when compared to the server. However, sometimes the uniqueness is something to leverage and embrace, not eliminate.

We are working on a white paper to try and explain the Express and Everywhere target scenarios. We hope to address the sprocs issue as well.

In short, we consider Everywhere Edition the default local database choice for local storage. Express may be used for local storage in extreme, but rare cases.
On the other hand, If you're locating data on a central machine for use by multiple people, then Express is your starting point. Express is our free, feature rich data as a service platform.
A perfectly valid scenario is Express on the central machine, and Everywhere Edition on the local machine.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

OS — Tue, 19 Sep 2006 18:32:20 GMT

I'm getting a protected memory access error at times while using the product in a multi-threaded application. What is the best forum to post this issue?

Branch, Branch, Branch!

OS — Tue, 19 Sep 2006 19:03:26 GMT

This product should be called SQL Server InProc and the code base should be split from the mobile version. Why?

In a short time, the number of users of the desktop version of SqlServerCe will far outnumber the Windows CE based users (a quick review of ms revenue splits by product division provides evidence for this).

Desktop machines have and will always have more capability than mobile machines. By splitting the code base you could add more features for your primary audience (desktop developers). Currently in SqlServerCe many basic SQL features are not available (SELECT TOP) multiple result sets, etc (sprocs would also be helpful but they should be restricted to operate on data within the database file only for security reasons). For the CE case it makes sense to leave these out because you are operating in a constrained environment. For the desktop version, doubling the size of the installed binarys would be of absolutely no consequence.

Furthermore, why should 95% of the users of this product have to use a somewhat confusing namespace "SqlServerCE"/"Microsoft SQL Mobile"?

re: Information about SQL Server Everywhere Edition (SSEv)

Matt — Fri, 29 Sep 2006 23:09:57 GMT

Will there be any support with BCP or similar tools to automate import or export of data from flat/text files?

re: Information about SQL Server Everywhere Edition (SSEv)

Chrsitian Melançon — Tue, 10 Oct 2006 17:11:57 GMT

Hi,

I was wondering if SQL Server Everywhere CTP or its final release will be 64-bit compatible?

Thanks!

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 14 Oct 2006 08:14:30 GMT

Hi Christian,

SSEv will have native 64 bit support, however, it's a bit out and won't be in the 3.1 release this year. Our current plan is to release 64 bit support in our 3.5 release next year.

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 14 Oct 2006 08:17:29 GMT

Hi Matt,

We do have some tools work in progress, but that's also a bit out and planned in the 3.5 release. It's a longer story, but shipping products at Microsoft has a lot of "taxes". We have UI guidelines, accessability, globalization and localization, many platforms to support etc. The dev work is actually the easy part.

I don't have any links handy, but I have seen the community and partners develop tools based on the SqlCeResultSet api that are very fast.

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 14 Oct 2006 08:22:10 GMT

Hi OS,

Names, names, what's in a name anyway? At the end of the day, do you really care what the name is? <g> Or do you care what it does?

We are adding additional query features in the 3.5 release, so some of these features will be coming.

As for the namespace, we purposely didn't change it as we didn't want to break any existing code. One of the main values is the ability to share code from device to desktop. This is also why we don't want to introduce yet further differences between the device and desktop versions.

As for size, well, even though SSEv is a fraction of the size of Express, in many cases it's still too big, even for desktop and we are doing some factoring work that will reduce the overall sizes further. ...I'm talking about future releases past 3.1

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 14 Oct 2006 08:24:23 GMT

Multi-threaded support-

It would be great to get some repro code. The team monitors this forum:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

re: Information about SQL Server Everywhere Edition (SSEv)

Neal Davis — Fri, 20 Oct 2006 03:40:07 GMT

I downloaded the sample Northwind.sdf database, it has spaces in many of the column field names? However the Northwind.mdb and the SQL Server Northwind database samples do not have spaces in the column field names. Why did they put spaces in the Northwind.sdf database field names? I have always been taught that is really "bad" it also makes it hard to write SQL statements in code - I guess you have to bracket each field name that has a space? example INSERT INTO Employees ([Employee ID], ... is that how you handle spaces in field names for SQL Everywhere northwind.sdf?

But I am very excited about SQL Everywhere I hope Microsoft makes it a replacement for Access and gives it limited multi-user connections (like maybe upto 5 or so) and would like multiple connections from different processes which I think I read you can do! Great work - this is what I need for my applications and I need both native and managed capability.

Neal Davis

re: Information about SQL Server Everywhere Edition (SSEv)

Cassio — Mon, 23 Oct 2006 04:00:54 GMT

Hi Steve,

My company have a smart client application that uses cached data in XML files for offline access. These files are getting larger each day and to query it using DOM is causing performance problems.

So I started playing with SSEv to see if we would have any problem to use this aproach instead of XML files.

Everything worked great, except for one thing. Let me explain the scenario.

Whenever we have to change the data schema, the smart client application have to download the whole XML files again. Because the XML files are now 50MB large, the server side uses a zip compression algorithm that reduces these files to 4MB, the client app downloads the file and decompresses them. We use Agile, so these schema changes are not so rare.

Testing with SSEv the .sdf file size was around 23MB, but there was no way to compact it. I tried the Compact() and Shrink() methods with no success. I even tried using WinRar, but the file size remained the same.

Is there any special way to compress the .sdf file size?

Thanks,

Cassio Alves

re: Information about SQL Server Everywhere Edition (SSEv)

David — Mon, 23 Oct 2006 17:15:58 GMT

It has been a while since I have done any SQL Server work, but I was wondering how I would retrieve identity values without stored procedures?

Also, without SProcs, there is a real burden put into the code side for any non-trivial transaction programming. I would need to code my multi table updates through ADO and block transaction them in code.

Or am I missing something?

Thanks

David

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Thu, 26 Oct 2006 17:05:00 GMT

Northwind Spaces:

In one sense I agree, and think spaces in column names is just a bad design and leads to all sorts of problem. However, for better or worse, it is supported. Our sample databases are typically built to help test out the features in the product. That can go overboard in many ways. The Northwind sample for SSEv, or the AdventureWorks sample that ships with SQL Server 2005 which had feature soup and just went overboard as well.

The teams are working on a simplified, more realistic version of AdventureWorks. We’re hoping to have that sample available for SSEv as well.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Thu, 26 Oct 2006 17:14:16 GMT

XML Compression:

Hi Cassio

I’m not sure if you’re asking if inserting XML data can be compressed, or just how to use the Compress API on the SSEv engine.

To compress the database:

Close all connections and call SqlCeEngine.Compact (<new database name>)

Change the value of auto shrink threshold to 10% in the connection string.

Compact will make a copy of the database in a compressed format. SqlCeEngine.Shrink() will clean up deleted pages in the same database file.

Since xml file is almost like a text file, compressors like winzip, winrar can apply their text compression algorithms. That’s the reason why you’re seeing a good amount to size decrease in your XML file. When the same data is stored in our database, we don’t store them in plain text. So these compression algorithms cannot play a huge role here.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

Oli — Fri, 03 Nov 2006 20:37:33 GMT

Any news re the release date? Thx, Oli

SQL Server 2005 Everywhere Edition - lightweight, flexible, free datastore

Robert Burke's Weblog — Tue, 07 Nov 2006 14:46:34 GMT

SQL Server 2005's Express Edition is free, it supports database sizes up to 4GB, it allows seamless upgrades

SQL Mobile on Desktop

SQL Server Everywhere Blog — Mon, 20 Nov 2006 12:52:23 GMT

Hi and welcome to the SQL Mobile blog! The SQL Mobile team wants to make this blog a place where we can

re: Information about SQL Server Everywhere Edition (SSEv)

gabe — Wed, 29 Nov 2006 03:04:52 GMT

I've been looking for GetSchema support (System.Data.Common.DbConnection) in SqlCE, but I'm not seeing it. When I attempted to execute GetSchema I recieve: System.NotSupportedException: Specified method is not supported.

Is this something I can look forward to in the 3.1 rtm?

re: Information about SQL Server Everywhere Edition (SSEv)

Arasu — Mon, 04 Dec 2006 05:06:44 GMT

Can someone point me to a C++ example for SSEv? (not .NET) - want to learn about moving a JET database to SSEv.

re: Information about SQL Server Everywhere Edition (SSEv)

WishfulDoctor — Sat, 09 Dec 2006 04:15:14 GMT

Apologize in advance if this is not the place for this question & for a newbie question to boot.

Can I use SSEv (Compact Edition) as a replacement for JET for a native c++ application. The (unmanaged, not .NET )application uses ADO to connect to the JET database & uses MDAC & JET components already in Windows. With Vista, there is no JET & I want to know if I can use SSEv. All the examples and discussions are ADO.NET & I cannot now move to .NET. Do I need to? The way I read the material so far, all I need to do is copy the needed dlls & register them, convert my .mdb to a .sdf file, change the connection strings and I should be in business. Is it as simple as that?

Once I again, I apologize if this is not the right forum - just point me to where I can get help. By the way, the folks at MSDN managed forum for Database say that they do not support SSEv.

Getting Started with SQL Compact Edition (Formerly “SQL Everywhere")

Guy Burstein's Blog — Mon, 01 Jan 2007 19:38:25 GMT

I have recently joined with a project that looks for a In-Memory Database for client-side caching solution.

re: Information about SQL Server Everywhere Edition (SSEv)

Dave Goldstein — Thu, 04 Jan 2007 20:04:46 GMT

I miss most of all the ability to define views. I do not understand your comment that it is for "multi-user abstractions".

Most uses of views encapsulate complex queries or joins or computed columns, so that these details can be encoded once and then reused everywhere.

Views that roll-up or join data also allow high level tools (like grid widgets) to be given (what appears to be) a simple table name instead of a complex query.

If we need to give up some view features (like updatable views) in order to have them at all, that would still be a great start!

SQL Mobile on Desktop

sql server compact edition — Sat, 13 Jan 2007 13:09:36 GMT

Hi and welcome to the SQL Mobile blog! The SQL Mobile team wants to make this blog a place where we can

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Tue, 16 Jan 2007 20:25:28 GMT

Hi WishfulDoctor,

The answer to your question is yes, but not as clean as we'd like. There is full support for SQLce in native code, but full doesn't necessarily mean consistent with MDAC. The RecordSet model isn't fully supported in the native stack of SQLce, so while you can use SQLce from native code, the communications are a little lower level. There's a little info here in this blog post from the team: http://blogs.msdn.com/sqlservercompact/archive/2007/01/13/windows-2000-support.aspx.

We will continue to support native development, but don't have official plans on adding support for the recordset programming model of MDAC. While I'm focused on managed development, I can't help but point out that Vista comes with .NET FX 3.0, but that's just a plug from the Developer Division.

Steve

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Tue, 16 Jan 2007 20:38:00 GMT

Hi Arasu,

Here's some samples posted by the SQLce team:

http://blogs.msdn.com/sqlservercompact/archive/2007/01/13/windows-2000-support.aspx

The topic says Windows 2000, but within the post, there's a link to:

http://msdn2.microsoft.com/en-us/library/ms173261.aspx

Steve

用 SQL Server Everywhere 保存离线数据

Bob Li — Tue, 06 Feb 2007 09:15:57 GMT

SQL Server Everywhere (SSEv) 是 SQL Server Mobile 2005 (SSM) 的下一个版本，版本号为 3.1，而 SSM 的版本号是 3.0。SSM 支持 Windows CE、Pocket PC、Smartphone 和 Tablet PC，而 SSEv 还增加了对 Desktop PC 的支持，再一次把移动数据库推向一个新的高潮。

re: Information about SQL Server Everywhere Edition (SSEv)

Neal Davis — Fri, 09 Feb 2007 23:23:54 GMT

Steve;

Do you think Microsoft will eventually create a UI application for SSCE like it has for Access? That is, an application that allows you to easily create tables, columns, rows, etc. just like the MS Access application allows you to do with .mdb files?

Neal Davis

re: Information about SQL Server Everywhere Edition (SSEv)

Steve.Lasker — Sat, 24 Feb 2007 22:09:46 GMT

Hi Neal,

Do you need yet another application to do this? Today, we have Visual Studio and SQL Server Management Studio for developers/DBA's. If we enabled Access to work over SQLce, would that be what you're looking for? Essentially, the answer is we don’t want to create yet another application, but rather enable SQLce within the existing tools and environments.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Matt — Mon, 02 Apr 2007 22:53:15 GMT

When creating a SQL Server Compact database/connection initially on a .NET application, the engine appears to hang for about 15 seconds. This happens only once when the database components are initially used, future connections or database activity cause no delays. I also see this delay when using Microsoft SQL Server Management Studio to connect to SQLCe databases. Is there a way to eliminate this initial delay?

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Tue, 03 Apr 2007 07:31:22 GMT

Hi Matt,

I can't say I've seen this. Typically, CE connections are near instantaneous. Could you confirm you're using SQLce 3.1 http://microsoft.com/sql/compact ?

It would be good to get some info on your environment, OS, etc. Please feel free to send to my email via the link in the top left corner.

Steve

.NET Client Application Services

Brad Abrams — Thu, 24 May 2007 06:40:20 GMT

One of my favorite features in Orcas is the ability to leverage the ASP.NET Application services from

SQL goes wild everywhere

Nick's .NET Travels — Thu, 30 Aug 2007 09:36:36 GMT

Since the release of SQL Server 2005 late last year the mobile devices community have been discussing

re: Information about SQL Server Compact Edition (SQLce)

dotnetguts — Wed, 05 Sep 2007 09:39:28 GMT

Thanks for help.

I also found a good collection on it

http://dotnetguts.blogspot.com/2007/08/sql-server-faq-interview-questions.html

http://dotnetguts.blogspot.com/2007/08/sql-optimization-tips.html

New and Notable 101

Sam Gentile — Tue, 25 Sep 2007 09:41:56 GMT

Not much today. WCF/SOA/WSE The WCF RSS Toolkit is a Windows Communication Foundation-based framework

re: Information about SQL Server Compact Edition (SQLce)

Robert — Wed, 28 Nov 2007 01:43:38 GMT

How can I open (in an application) a protected .sdf database ; I used this code but doesn't work:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim objConn As New SqlCeConnection

Dim pwd As String = "RMN123!@#"

Dim connStr As String = "Data source=\My Documents\b1.sdf; SSCE:Database Password=pwd"

objConn.ConnectionString = connStr

objConn.Open()

Me.AG1TableAdapter.Fill(Me.B1DataSet.AG1)

If you can help me send an email at radunicolae1@yahoo.com

Thanks

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Wed, 28 Nov 2007 02:02:34 GMT

Hi Robert,

Your hitting a common string concatenation issue. Your code above is setting the password = to the literal value; pwd, rather than the value of the pwd variable.

Dim connStr As String = "Data source=\My Documents\b1.sdf; SSCE:Database Password=" + pwd

Or String.Format("Data source=\My Documents\b1.sdf; SSCE:Database Password={0}", pwd)

Steve

re: Information about SQL Server Compact Edition (SQLce)

Robert — Wed, 12 Dec 2007 16:43:54 GMT

I put the string like you said and I thank you Steve , but if I do not comment the last line ( 'Me.AG1TableAdapter.Fill(Me.B1DataSet.AG1) )

I still get the error : "The specified password does not match the database password"

____________________________________________

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim objConn As New SqlCeConnection

Dim pwd As String = "RMN123!@#"

Dim connStr As String = "Data source=\My Documents\b1.sdf; SSCE:Database Password=" + pwd

objConn.ConnectionString = connStr

objConn.Open()

Me.AG1TableAdapter.Fill(Me.B1DataSet.AG1)

End Sub

--------------------------

I verified the password for the database (b1.sdf) by opening it directly ('double click' on the pocket-pc and manually providing this password : RMN123!@# )

Thank you for your advice and understanding

accessing a password protected .sdf database

Robert — Thu, 13 Dec 2007 14:36:11 GMT

Maybe the last line is not in relation with the others because I still get the error message "the specified password does not match the database password "

_____________________________

Dim objConn As New SqlCeConnection

Dim pwd As String = "RMN123!@#"

Dim connStr As String = "Data source=\My Documents\b1.sdf; SSCE:Database Password=" + pwd

objConn.ConnectionString = connStr

objConn.Open()

Me.AG1TableAdapter.Fill(Me.B1DataSet.AG1)

------------------------------------------

Thank you for your answer

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Sat, 15 Dec 2007 05:11:07 GMT

Hi Robert,

I see your using a new SqlCeConnection, setting it up, then calling Me.AG1TableAdapter.Fill. What's happening is the TableAdapter doesn't automatically associate with the new connection you're creating. If you look in the Settings Designer, you should see the connection string the TableAdapter uses and can set it there.

You can also set the ConnectionString on the TableAdapter. That will get them together and it should work.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Robert — Mon, 17 Dec 2007 14:58:45 GMT

Thank you, setting the password works fine.

Now I have another question:

is there any possibility to protect a pocket-pc application ?

That means when somebody (unauthorized) tries to copy the application (wich consists of these two files - the database.sdf and the executable itself) to get the message "Sorry, you don't have rights to use this application...". I saw that exists a function like : IOCTL_HAL_GET_DEVICEID but I also understood that not all of the pocket-pc support this .

I try to read at the begining of the application the "Device-ID" of the pocket-pc; if this is the one where I installed the application -continue , otherwise-Exit application.

Thank you very much for your help

re: Information about SQL Server Compact Edition (SQLce)

Robert — Wed, 19 Dec 2007 00:58:24 GMT

Hi Steve,

now comes the more difficult part for me ; I want to make an application which uses both a desktop (or two ,in a network) PC and 4 Pocket-PC's ; to be more concrete it's about registering on Pocket-PCs the orders made by customers in a little resturant at each table by a waiter and transmit the orders from these 4 tables to the Database on the desktop PC which could be placed in the kitchen,for example (like a client-server application); What do you sugest me to use in this case ; can I use Visual Basic 2005 to make this kind of application ? What database software do I need exactly (for PC and for Pocket-PCs); I did't see the relation between a .mdf file and a .sdf file (like it is when I use Access - with .mdb file , and when transferring on Pocket-PC it is transformed by conversion in a .cdb file with same data); can I do a transfer from a .sdf database (pocket-pc) to a database on a desktop PC ?

I also intend to make the connection (synchronization) by WiFi.

Thank you very much for your help.

re: Information about SQL Server Compact Edition (SQLce)

Robert — Thu, 20 Dec 2007 18:21:12 GMT

I managed to resolve the problem with Device_ID

re: Information about SQL Server Compact Edition (SQLce)

ROBERT — Thu, 27 Dec 2007 17:28:32 GMT

Hello Steve,

How can I restructure a .sdf SQL CE database ? (inside Visual Studio 2005 I didn't find any possibility)

Thank you for your answers

re: Information about SQL Server Compact Edition (SQLce)

ROBERTO — Sat, 29 Dec 2007 13:45:00 GMT

Hi Steve,

How can I open another form from the first one in an application with a SQL Server Compact Edition database (from Form1 I cannot find the function to open the Form2 ) ; Form1 is for selection (Query) and Form2 is for entering new data in the .sdf database

Thank you very much

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Wed, 09 Jan 2008 18:06:14 GMT

Hi Robert,

by restructure, do you mean edit the schema of the tables? VS 2005 supports tooling for SQLce 3.1. VS 2008 supports tooling for SQLce 3.5.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Wed, 09 Jan 2008 18:10:53 GMT

Hi Reberto,

Interacting with forms can be done in a few ways. VB added the My namespace in VS 2005 so developers can simply say My.Forms.Form2.Show()

Both VB and C# can use the traditional .NET object instantiation of:

VB:

Dim form2 as New Form2()

form2.Show()

C#:

Form2 form2 = new Form2();

form2.Show()

To pass info into Form2, you could overload the Show method

form2.Show(parameter for PK)

or provide another method

form2.LoadCustomerById(idOfCustomer)

You might want to do some reading on Windows Forms for desktop or device as this model is common to both.

Steve

License Policy

David Murillo — Thu, 17 Jan 2008 19:36:10 GMT

Hi Steve

I need to know if my client needs a type of CAL for an application that use a Mobile stand alone data base instaled in a device.

I'm using SQL Server CE

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Fri, 18 Jan 2008 17:50:35 GMT

Hi David,

SQL Server Compact is free to use, free to distribute, and free to embed within applications, so no, you don’t need any CAL’s to use SQLce.

Connecting to SQL Server, whether through ADO.NET, Sync Services or Merge Replication requires a CAL for each connection, but that's unrelated to the source that happens to be SQLce.

The thing to not is SQLce doesn’t give people a free CAL to SQL Server.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Gilad — Sun, 27 Jan 2008 15:28:44 GMT

If the Compact edition will throw an exception when trying to use it from a process hosted by IIS I can state that I will look for a different databse solution for my product.

Gilad.

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Sun, 03 Feb 2008 05:59:41 GMT

Hi Gilad,

What we're trying to do is simply let developers know that SQL Server Compact, like other products in the same space, simply don't compare with SQL Server. We do support you 'unblocking' it for ASP.NET usage, but wanted to put a "sign" up so developers knew. I'd suggest that other products in this space are no better, and in most cases worse for these scenarios under any sort of load.

For how to unblock, and the reasoning, here's a post: http://blogs.msdn.com/stevelasker/archive/2006/11/27/sql-server-compact-edition-under-asp-net-and-iis.aspx

You can also simply check the SqlCeConnection docs, and you'll see how the official documentation we placed in the product.

Steve

Use SQLCE with VB.Net Express

Heine — Fri, 04 Jul 2008 21:24:17 GMT

Is it possible to program SQLCE from VB.Net Express 2005 or Express 2008? When I do "add new data source" I don't see the SQLCE provider? I only see SQL Server and Access providers? I am able to create a SQLCE database from SQL Server Express Management Studio. I want to use the dot net 2 framework. So that's version 3.1 right?

I also tried using it from vb6 but I don't see the oledb provider. I got the version of SQLCE that came with SQL Server Express 2005 sp2, but I also downloaded version 2005 (3.1) and installed it.

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Wed, 09 Jul 2008 23:30:39 GMT

Hi Heine,

Unfortunately, we don’t have support in VS 2005 Express as Compact was released for desktop usage after 2005 shipped, and 2005 shipped SQL Server Mobile for the Windows Mobile platform which didn’t ship in any Express SKUs. I discussed the 2005 configuration steps here. However, you can use Compact 3.1 or 3.5 from VS 2005 Express in coding scenarios by simply adding a reference to the managed provider and partying away in VB.net or C#. It’s really a tools limitation in 2005.

In 2008, we have full support for Compact 3.5 across all VS and SQL Server SKUs, including Express. The one exception is the VS 2008 Web Express SKU as we don’t yet have Compact enabled for web development.

For VB6, while Compact does have an OleDB interface, it’s really targeted at the subset required for Windows Mobile. It’s not a “full OleDb provider” required for desktop designer scenarios which is why you don’t see it as an option in any of the tools. We have discussed expanding our OleDB support, but with our forward progress in .NET, we felt it best to look forward and do that much more in .NET. That said, you could write a .NET assembly doing your data access, can enable that assembly for COM consumption.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Heine — Thu, 10 Jul 2008 18:40:25 GMT

Is it possible to use SQLCE 3.5 with the dot net 2 framework? Alternatively can you use SQLCE 3.1 from VB Express 2008? I coudn't add a new data source. I would like to visuallly define connections etc but I must use VB Express 2005/2008 with the dot net 2 framework.

Is my only option to make a referance to the DLL?

re: Information about SQL Server Compact Edition (SQLce)

Heine — Sun, 13 Jul 2008 19:37:32 GMT

I downloaded the latest version 3.5 SQLCE and also the books online. I went thru the examples.

It looks like when you want to use SQLCE for desktop apps and program it with managed code then you have to set a reference to the SQLCE namespace. It looks like you can't use ado.net.

I am using VB Express 2008. Is this correct?

re: Information about SQL Server Compact Edition (SQLce)

Heine — Mon, 14 Jul 2008 00:06:41 GMT

I read a couple of things in the SQLCE books online. Apparantly you can perform a shrink operation on the database and you can also set an option to auto shrink. There is also an option to compact the database. Do you HAVE to perform a shrink? Doesn't it re-use deleted space like SQL Server Express or the paid versions of SQL Server? Does auto shrink slow down your database operations dramatically? Is the purpose of compacting the database to remove fragmentation? I know in Access you have to compact in order to remove deleted space. In both cases it rebuilds the database when compacting. Just out of interest, how long does it take to compact a 4 gb database? Does SQLCE have any advantages over JET 4.0?

(Access 2003) I know that JET 4.0 got a very small memory footprint but there are a number of DLL's to deploy. It's not as easy as SQLCE for deployment. Also, you need to buy Office in order to create/edit databases. Access 2003 is also limited to 2GB vs SQLCE's 4GB database limit. I know SQLCE 3.5 needs 256MB RAM minimum, but what is the recommended memory requirements for SQLCE? SQL Server 2008 Express, which is still in beta, also has 256MB minimum memory, but the recommended memory is 1gb.

re: Information about SQL Server Compact Edition (SQLce)

Heine — Mon, 14 Jul 2008 01:06:44 GMT

I read on another blog that you can install the design tools for SQLCE manually. I grabbed my Visual Studio Express DVD and did exactly that.

I was able to go add new data source and I was able to view data in a simple form. I am sorry to bother you, but would you still consider answering my other questions? Yes you are right, you can only use the dot net 3.5 framework. I tried older versions of the dot net framework and got lots of compile errors.

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Tue, 15 Jul 2008 03:53:02 GMT

SQL Server Compact is based on a dependency of .NET FX 2.0. .NET FX 3.0 and 3.5 are really 2.0 +, +. This is what happens when marketing and branding get involved in code versioning… 

Due to the way VS 2005 and SQL Server Mobile 3.0 were packaged, we couldn’t achieve VS 2005 Express designers, so in 2005, yes, you’ll need to work in code.

However, during 3.5, we did the work to enable Express designer support, so in VS 2008 you can use the designers across all the SKUs. …but only for SQL Server Compact 3.5. We weren’t able to add multi-version tooling support in this release.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Tue, 15 Jul 2008 04:09:36 GMT

Shrink is only required if you want to force the shrink operation immediately. You can sort of think of it like Garbage Collection. It will kick in automatically, but sometimes you want to say “now”.

Similar to GC, it doesn’t slow things down as it’s fairly efficient on when to perform compaction, so it’s typically best to let it do it’s thing. If you’ve done a lot of deletes and you need to recapture the space immediately, you may need to call Shrink.

There are many advantages over Jet, and some disadvantages. With Compact, you can privately deploy the database engine directly with the app. Jet is currently in many operation systems already, but is it the version you need? Compact also has much better tooling in VS and SQL Server as this is the database DevDiv and SQL are focused on. That said, Compact doesn’t have direct tooling support in Office yet as we’re not actively pursuing OleDB yet, and Office is just starting to “embrace” managed code.

I’m not sure where the 256mb min RAM came from, as it’s not really a Compact requirement, but rather an overall Windows and .NET FX requirement. Compact consumes only a few megs, based on the size of the database. Based on Windows Mobile requirements, you should never be limited in memory by Compact. Rather WPF, WCF, .NET FX, etc.

Steve

re: Information about SQL Server Compact Edition (SQLce)

Heine — Thu, 17 Jul 2008 19:24:12 GMT

How do you browse a SQL Server Compact 3.5 database without installing Visual Studio 2008?

Say if you got a database on a customer's pc and you want to browse the data or execute queries for the purpose of troubleshooting?

Something like query analyzer or SQL Server Management Studio? Or do you have to copy the

customer's database onto your laptop and browser it there from Visual Studio?

Heine

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Sat, 26 Jul 2008 01:07:24 GMT

Hi Heine,

Our tools for Compact 3.5 are composed into Visual Studio 2008 and SQL Server Management Studio 2008. The good news is we now have full support in the Express SKUs of VS and Management Studio, but they are "installs".

For stand alone tools, or even tools that could be run directly from a DVD, you could expand upon this sample I’ve provided here, the database viewer. It simply displays data, but you could expand upon it to show a graphical showplan with WPF, or other neat things. There are several MVPs that have tooling external to VS, but they do need to be “installed” as well.

Steve

SQLCE and next version of Office

Heine — Fri, 01 Aug 2008 21:34:44 GMT

What do you think are the chances that SQLCE will be bundled with the next version of Access? My real question is if it will be possible to develop a front end with the next version of Access and use SQLCE as the back end? It should be possible in theory, but I don't know if Microsoft would want to go that route.

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Sun, 03 Aug 2008 17:49:24 GMT

Hi Heine,

It’s hard to say “Microsoft would want to go that route”, as Microsoft is such a big company made up of so many product units and teams. As for packaging with Access, it’s not currently on our plan. Because Compact is used in so many scenarios and products, it’s difficult to “pursue” each one individually. We’ve been working to release Compact as an independent product that other teams can “pick up”. While not directly linked to Access we will have future Office usage, but you’ll have to wait for PDC for that :)

Steve

re: Information about SQL Server Compact Edition (SQLce)

Anthony Wieser — Thu, 04 Sep 2008 14:16:36 GMT

Is there a front end for editing the contents of an SQL CE 3.5 databases anywhere?

I'm developing with VS2005, but sometimes just need a quick and dirty way to display and edit fields in the database.

Is there any simple way to do this? Access 2007 doesn't know how to attach an OLEDB table, and SQL Server Management Studio 2008 can display the results of a query, but doesn't seem to allow you to make any changes to the data?

Is it easy to knock up a simple .NET app that just displays a grid with the fields you can edit for example? I've tried connecting using Excel 2007, and keep getting a message that the table doesn't exist after going through the wizard.

Anthony Wieser

Wieser Software Ltd

Editing and browsing SQLCE

Heine — Thu, 11 Sep 2008 20:54:48 GMT

Is there a way that you can download and install SQL Server 2008 Management Studio Basic on its own? I know it comes with SQL Server 2008 Express but I just want Management Studio Basic to browse SQLCE databases. Do you know what the minimum requirements are for Management Studio Basic? Some times you don't want to install everything just the management studio basic.

Heine

re: Information about SQL Server Compact Edition (SQLce)

Steve.Lasker — Fri, 12 Sep 2008 14:10:56 GMT

Hi Heine,

While we hoped to have a Management Studio Tools stand alone release, the Express team did fall back to only supporting a download that included the Express engine as well.

You can use VS 2008 Express (VB/C#) as small tool downloads to manage Compact databases as well. Will that give you what you need? Or do you need the Query Editor and Graphical Showplan features that currently only ship in Management Studio?

Steve

re: Information about SQL Server Compact Edition (SQLce)

Heine — Fri, 12 Sep 2008 18:05:09 GMT

I wanted a light weight product that would be able to browse and edit SQLCE databases. One that would be able to run on an XP machine with only 128MB RAM. I suppose it's not too dificult to write your own tool. I don't mind typing queries manually as long as I can see the results of those quries.

re: Information about SQL Server Compact Edition (SQLce)

Heine — Tue, 16 Sep 2008 17:43:06 GMT

Steve,

I also posted the same question in the SQL server forum and they said that during the SQL Express installation, you can choose to only install management studio basic. That sounds like the answer I was hoping to hear. I have already downloaded SQL 2008 Express, but I just wanted to know if it is possible to only install the managment studio basic.

New and Notable 101

Sam Gentile's Blog — Fri, 05 Dec 2008 17:44:05 GMT

Not much today. WCF/SOA/WSE The WCF RSS Toolkit is a Windows Communication Foundation-based framework for generating RSS 2.0 and Atom 1.0 content feeds Steve Maine on the WCF RSS Toolkit The latest WCF Documentation CTP (June 2 release) is now available

Database persistence

William — Wed, 04 Feb 2009 09:51:40 GMT

Hi,

I realise that this is a bit of an ask, but I'm hoping that you can help. I've been scratching my head for a while over various versions of this code snippet:

string constr = "Data Source=\\storage card\\People.sdf";

SqlCeConnection conn = new SqlCeConnection(constr);

conn.Open();

SqlCeTransaction t = conn.BeginTransaction();

SqlCeCommand cmd = new SqlCeCommand("INSERT INTO People VALUES(@name, @age)", conn);

cmd.Parameters.AddWithValue("@name","William");

cmd.Parameters.AddWithValue("@age","4");

cmd.ExecuteNonQuery();

// here, I can read back the data with a SELECT and confirm

// that a new row has been created in the database...

t.Commit();

conn.Close();

Basically, the issue is that once I close the program the newly inserted row vanishes from the database. I can verify this using 'Query Analyzer 3.5' on the device... any ideas?

Information about SQL Server Compact Edition (SQLce)

Syringe.Net.Nz - SQL Server Everywhere....

SQL Server Everywhere — всё проясняется... [Стив Ласкер]

SQL goes wild everywhere

SQL Server Everywhere FAQ

SQL Server Everywhere FAQ

Information about SQL Server Everywhere

re: Information about SQL Server Everywhere (SQL Everywhere)

Interesting things about SQL Server Everywhere

Hvad er SQL Server Everywhere?

SQL Everywhere and why I don't get it.

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Everywhere FAQ

Good news for smart client developers: SQL Server Everywhere

SQL Server Anywhere FAQs

SQL Server Anywhere FAQs

re: Information about SQL Server Everywhere (SQL Everywhere)

Information about SQL Server Everywhere (SQL Everywhere)

Informazioni su SQL Server Everywhere (SQL Everywhere)

The Lowdown on SQL Server Everywhere Edition

SQL Server Everywhere

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Server Everywhere

Random Things

SQL Server Everywhere

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Server Everywhere 追加情報(SQL MobileのWindows desktop 展開)

SQL Everywhere Q & A

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Server Anywhere FAQs

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

Info about SQL Server Everywhere

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

The Mobile Minute 137

SQL Mobile goes Everywhere!

re: Information about SQL Server Everywhere (SQL Everywhere)

Informaci

SQL Mobile on Desktop

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL/e

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Everywhere : SQL Mobile 2005 port&#233; sur PC

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

Catching up.

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

MEDC 2006 Europe Keynote - DONE!

Tools &amp; Help For Building Mobile LOB Applications

SQL Server 2005 Everywhere Edition - lightweight, flexible, free datastore

TechEd에서 발표된 것들

re: Information about SQL Server Everywhere (SQL Everywhere)

New and Notable 101

CTP of SQL Server 2005 Everywhere Edition Now Available

Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

re: Information about SQL Server Everywhere (SQL Everywhere)

SQL Mobile on Desktop

SQL/E Windows 2000 support

ADO.NET and SQL Server Everywhere

SQL Server Everywhere

ADO.NET and SQL Server Everywhere

re: Information about SQL Server Everywhere (SQL Ev, SQL/e)

SQL Server Everywhere (SQL Ev, SQL/e)

re: Information about SQL Server Everywhere (SQL Ev, SQL/e)

SQL Everywhere : SQL Mobile 2005 porté sur PC

Tools & Help For Building Mobile LOB Applications