Does "SQL Server 2005 Mobile Edition" exist?

"SQL Server 2005 Mobile Edition" is a standalone software?

or

it equals "SQL Server 2005" + "SQL Server 2005 Mobile Edition Device SDK"?

Hi Raphael,

You need to download SQL Server 2005 Mobile Edition Device Device SDK which is the standalone software. You do not need SQL Server 2005 on the desktop unless you plan to sync your Mobile data to a SQL Server using Remote Data Access (RDA) or Merge replication. Otherwise you only need SQL Server 2005 Mobile Edition Device Device SDK.

Here is a sysreqs url which has all this mentioned there :

http://www.microsoft.com/sql/editions/sqlmobile/sysreqs.mspx

Hope that helps,

Amol.

|||

Amol.

Thank yor for your help!

I have seen the link you provided before and read some other articles. But too much information make me quite confused.

My situation is that I need to create a mobile application (use SQL server mobile) in the device. Also, I need to sync my mobile data to a SQL Server.

Questions:

Then I want to ask "SQL Server 2005 Mobile Edition" is a standalone software like "SQL Server 2005 Express Edition"?

Or "SQL Server 2005 Mobile Edition" is a compact database stored in device, can use "SQL Server 2005 Express Edition", "SQL Server 2005 Standard Edition",......etc to open it on server side?

|||

Hi Raphael,

SQL Server 2005 mobile edition IS a standalone software which runs by itself on the device. The data is stored with a small footprint on the device. It's like having a server and its data on the device which u carry around. As an enterprise requirement, you can connect to a SQL Server 2005 running in your enterprise and sync your device data with the server data. I believe you can also connect to a SQL Server from your device to view and work with the server data.

Regards,

Amol.

|||Thank you!|||

Hi Amol,

I am also running 2005 mobile ed. on a handheld. I'm trying to replicate the data to a PC running SQL 2005 Express then have Express replicate to an Enterprise SQL Server. I understand that Express can only be the subscriber. Is it possible although I'm synching to a PC (thru a cradle) to replicate the 2005 mobile DB to an enterprise SQL Server directly, bypassing the PC with Express?