SQL Server COmpact Edition vs MObile Ed.

[gRob_AndDerSon]

Whats the difference between the SQL Server Compact Ed. and Mobile Ed.

Im using Mobile Ed. in application in VS 2005, can I use Compact Ed in .Net Compact Framework 2.0

[szlamany]

Mobile Edition has been replaced by Compact Edition

http://www.microsoft.com/sql/editions/compact/default.mspx

I am home now - but I do believe that 2.0 is the only framework requirement for SQL CE

[gRob_AndDerSon]

If I upgrade my SQL Server Mobile Ed. to SQL CE, are there issues to be considered..

And how can I migrate my SQL ME database to SQL CE??

[petevick]

Hi,
what reference are you using in your project for SqlServerCE - that will tell us what version you are using, as it is quite confusing. The confusion is not helped by Microsofts naming policy.

Pete

[gRob_AndDerSon]

In my project References, I have:
Microsoft.WindowsCE.Forms
Microsoft.WindowsMobile.Forms
System.Data.SqlClient
System.Data.SqlServerCE

I dont know why I have this.
Can you explain to me what specifically in my project uses the References Above. It's confusing

[petevick]

Which path does system.data.sqlserverce reference?

[gRob_AndDerSon]

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll

[petevick]

Hi,
ok - so you appear to be using the latest version - Sql Server 2005 Compact Edition.
This shouldn't be a problem

Pete

[gRob_AndDerSon]

Ah Ok... Is there a way to convert SQL ME database to SQLCE??

[petevick]

Hi,
so you want to move BACK a version?

Pete

[gRob_AndDerSon]

I thought SQL Compact Ed. is much latest than SQL Mobile Ed.

[petevick]

As I said in an earlier reply, you are using the latest version - C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll

Pete