SQL Server Compact Edition 3.1 Released

re: SQL Server Compact Edition 3.1 Released

Richard Jones — Tue, 16 Jan 2007 23:31:29 GMT

Nice post.

Love the product.

Its made our work as a partner so much easier, with the work you guys put in.

Have the next snow storm on us :-)

re: SQL Server Compact Edition 3.1 Released

BestSnowman — Sat, 10 Feb 2007 09:34:52 GMT

I love SSCE, its like a dream come true!

Are there any plans for an x64 version? I tried deploying a .NET app that used SSCE with the AnyCpu tag on an Vista x64 system... that was fun :)

re: SQL Server Compact Edition 3.1 Released

Steve.Lasker — Sat, 24 Feb 2007 20:34:44 GMT

Hi BestSnowman

We definitely plan to support 64bit environments. Many of the components already work in 64bit, as parts of SQLce ship in Vista. However, the Vista work was all done before we made the final decision to release the whole stack as SQLce, so we still have some QA work to do in order to fully support 64. As to when, we were just discussing that yesterday. We didn’t originally plan to do it for the 3.5 Orcas timed release as it wasn’t thought to be a mainline issue for a while and we prioritized some other work, such as perf in front of it. Based on the proliferation of new 64bit machines, we may try to pull it into the 3.5 release, but no promises. But, have no doubts, SQLce is a major part of our future client plans, so we will support 64bit in the future.

Was that vague enough on when, but concrete on the commitment? <g>

Steve

re: SQL Server Compact Edition 3.1 Released

Steve.Lasker — Sat, 24 Feb 2007 20:35:47 GMT

Hi Jamome,

Thanks’ for the reminder. Let me ask the perf team for the status of the paper.

Steve

re: SQL Server Compact Edition 3.1 Released

BestSnowman — Sun, 25 Feb 2007 09:31:38 GMT

Great answer Steve, kind of the answer I was sort of looking for. I'll be looking forward to a 64-bit release :)

re: SQL Server Compact Edition 3.1 Released

casner — Tue, 13 Mar 2007 21:08:33 GMT

A bit of confusion here - your blog and some pages refer to 3.1 edition. Yet the sqlce when installed still is named sqlcecompact30.dll, so I'm not sure whether it is 3.0 or 3.1 for Windows CE installation.

re: SQL Server Compact Edition 3.1 Released

Steve.Lasker — Sat, 17 Mar 2007 21:13:10 GMT

Hi Casner,

For SQLce 3.1 we wanted to maintain backwards compat, and leverage all the 2005/3.0 designer and runtime support so we didn't actually change any of the physical versions. In reality, the 3.1 release was really about unlocking the device scenarios on the full desktop. SQLce 3.5, currently in CTP will have the native and managed dlls names changed to support full side by side of 3.x and 3.5. In hindsight, we probably should have made the 3.5 version 4.0 as it does have new feature work.

Steve

SQL Server Compact Edition 3.5 Questions

M. Gopalan — Thu, 26 Jul 2007 09:27:03 GMT

Dear Sir,

We are using SQL Server Compact Edition 3.5 and the front end is Visual Studio 2005 (VB.NET) windows application. We have some questions listed below:

1. What 3 ways to create a database (if possible give me a sample code)? and tell me the advantage of this 3 way.

2. We have a database in MsAccess97 its about 450 MB. We converted those datas into SQL Compact Edition 3.1 (.SDF format) it comes to 1.3 GB. Why its taking so much size? If any solution for this it will bge very helpful for us.

3. We found there is an option in the Provider String called "Encrypt Database=True;". We have used this option in our project but we don't find any changes happened in the database.

4. We are using a SQLCE database (1.3GB) in our application. While querying a table will take a minimum of 1 minute to retrieve the datas even though we did the Indexes for all the tables..

Awaiting for your response.

Thanks

M. Gopalan

Sofist India

70, Thyagaraya Rd,

T. Nagar

Chennai 600017

Tamil Nadu, India

www.sofist.com

gopalan@sofist.com

re: SQL Server Compact Edition 3.1 Released

Steve.Lasker — Fri, 27 Jul 2007 05:06:00 GMT

Hi Gopalan,

When using SQLce 3.5 with VS 2005, you won’t be able to use the designers as VS 2005 does assume SQLce 3.1.

VS 2005 designers target SQL Server Mobile 3.0 and SQL Server Compact 3.1.
VS 2008 data designers target SQL Server Compact 3.5.

With that said, you can use the VS products interchangeably with the SQL Server 3.x products in code. Just reference the accompanying assemblies and use ADO.NET to execute commands. Here’s a link to the docs explaining the CREATE TABLE syntax: http://msdn2.microsoft.com/en-us/library/ms173393.aspx To execute these create and other T-SQL commands you can use the following code to execute scripts: Creating your SQL Server Compact Edition database and schema in code

The database sizes from Jet to SQLce does sound a bit strange. I can’t remember the Jet to SQLce comparison numbers, but the same schema in SQL Server is typically 1/3 in SQLce. Is it possible you’re using nChar(x) for string columns, rather than nVarChar(x).

Encryption: If you set a password, encryption is on by default. If you set encryption, you’ll notice you must provide a password. Once you open the database, you’re working with the data unencrypted through ADO.NET. Encryption is at the file level. If you attempt to open an unencrypted and encrypted file with notepad you’ll see the differences.

Lastly for performance, as with any database, it’s not about having indexes, but having indexes that serve the queries. This is where you can use SQL Server Management Studio to test your queries. Using SQL Server Management Studio you can execute the query with Show Plan to view how SQLce is executing your query. You’ll likely find the WHERE clause isn’t capable of using the indexes you’ve created.

Hope that helps,

Steve

re: SQL Server Compact Edition 3.1 Released

norpe — Tue, 21 Aug 2007 10:11:07 GMT

Any news on the 64-bit version? Our application cannot be supported on Vista x64 until SQLCE works on 64-bit.

re: SQL Server Compact Edition 3.1 Released

Steve.Lasker — Fri, 24 Aug 2007 06:49:59 GMT

Hi Norpe,

Nothing more specific to report beyond what I've posted here just yet:

http://blogs.msdn.com/stevelasker/archive/2007/07/11/sql-server-compact-and-64bit-support.aspx

I can say that we're actively working on portions of the 64bit scenarios, but really the team is focused right now on getting VS 2008 done, as well as SQL Server 2008. As soon as we get that done we can get the 64bit work started. We're still confident we can get it done as stated above,

As for your Vista 64 app, WOW mode won't buy you the time?