Migrating from 2005 to 2005 Mobile

Hello All,

I have a database created on SQL Server 2005 and now I would like to migrate the table structure to a SQL Server 2005 Mobile database. Generating the scripts and running them against the mobile database generates a lot of error that I suppose are caused by not supported features or keywords on the mobile engine.

I would like to know what are the best procedure for doing such migration. Note that this has nothing to do with replicating, since the SQL Server 2005 database will be "discontinued" after the migration.

Thanks in Advance,

Igor Kondrasovas

you have a variety of options

1) you can create a new SQL Mobile database, add a subscription to it that subscribes to a publication which consists of the entire SS2005 database, and then merge replicate

2) you can script the DDL of the SS2005 database and run each statement a line at a time from a simple CF application on device to recreate the skeletal database

I walk you through how to do option 1 in the MSDN webcast I gave in Nov 2005.

http://msreadiness.com/WS_abstract.asp?eid=15003229

Darren

|||

Hello Darren,

Thanks for the help.

I was thinking that there I could just do that using the Management Studio.

I found out a tool called DataPort Wizard that is capable of doing such think, including table data very easily. I hope Microsoft will provide a way for doing that the same way this tool does (very easy by the way).

The other thing is that if you decide to create you own Mobile Database you cannot easily define contrainsts (as foreign keys) using the "Table Creation GUI". Only defining Primary Keys is Allowed. Besides, if you have foreign keys defined you cannot see them on the Colums definition on Management Studio, as you can see on the SQL Server 2005 database. Please correct me if I'm wrong.

Best Regards,

Igor Kondrasovas

|||

You are correct - you cannot do much in terms of defining constraints or altering tables visually in VS2005 or SS2005, but to be honest, the SQL to do this from code (or in SS2005 Mgmt Studio Query Window) is not difficult.

Darren

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

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

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Microsoft.AnalysisServices.AdomdClient

Can anyone tell me if it's possible connect analysis services to an mobile application using AdomdClient..
If yes, how i do this?
If you are asking - is there a version of AdomdClient written for Windows Mobile, the answer is no. However, you can use XMLA directly to send queries to an Analysis Services server from any client|||Thank you. I can get data from Analysis Services, but now i want to show decision trees on mobile.. Do you know some king of AnalysisServices Viewer component for Mobile ?
|||There isn't that I know of, maybe you can modify the sample web viewer (inlcuded with SQL 2005) for this purpose?

Microsoft SQL Server Mobile Edition data source

i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true
anyway, on the 5th exercise wherein i'm supposed to add a new data connection through the server explorer.. when i chose the option of adding a new data source and was prompted to select a data source i couldnt find the Microsoft SQL Server Mobile Edition data source..
is there anything else that i need to download in order to have that data source?

1) Did your installation include "SQL Server 2005 Mobile Edition". Can you see SQL Mobile traces in "Add/Remove Programs" directory. Some thing like "SQL Server Mobile Developer Tools".

2) If yes, then can you please follow the thread@. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=260599&SiteID=1, and see if it helps you out.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||uh yeah. but mine says "Microsoft SQL Server Mobile 2005 Mobile [ENU] Server Tools" i got the sql server 2005 mobile edition by accessing the sqlce30setupen.msi file. also i already tried to add the following lines to the machine.config file but i still couldnt find it when i open vs studio 2005. anyway, if worst comes to worst and i cant figure this one out would you happen to know how i would configure the database connection for a pocket pc through the use of vs.net 2003?

<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />|||

Hmm...it looks like SQL Mobile Developer tools were not installed. Server Tools are not needed for you, they are meant for synchronization of SQL Mobile database with SQL Server. If you dont have Developer Tools, try installing the SQL Mobile Developer tools from the following location of your VS 2005 Disk: wcu\SQLCE\sqlmobile30devtoolsxxx.msi

The xxx in the MSI name stand for the locale, for english it would be 'enu'.

Let me know installing that worked for you.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||Dear Laxmi....

I also have the same problem and I tried to install the SQL Mobile Developer tools from VS 2005, but the location is not avalaible in the CD. I used VS PRo 2005.

Please help me because I have a project to write program for My Mobile Application that's need to connect to database.

Microsoft SQL Server Mobile Edition data source

i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

anyway, on the 5th exercise wherein i'm supposed to add a new data

connection through the server explorer.. when i chose the option of

adding a new data source and was prompted to select a data source i

couldnt find the Microsoft SQL Server Mobile Edition data source..

is there anything else that i need to download in order to have that data source?

1) Did your installation include "SQL Server 2005 Mobile Edition". Can you see SQL Mobile traces in "Add/Remove Programs" directory. Some thing like "SQL Server Mobile Developer Tools".

2) If yes, then can you please follow the thread@. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=260599&SiteID=1, and see if it helps you out.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||uh yeah. but mine says "Microsoft SQL Server Mobile 2005 Mobile [ENU]

Server Tools" i got the sql server 2005 mobile edition by accessing the

sqlce30setupen.msi file. also i already tried to add the

following lines to the machine.config file but i still couldnt find it

when i open vs studio 2005. anyway, if worst comes to worst and i

cant figure this one out would you happen to know how i would configure

the database connection for a pocket pc through the use of vs.net 2003?
<add

name="SQL Server CE Data Provider"

invariant="Microsoft.SqlServerCe.Client" description=".NET Framework

Data Provider for Microsoft SQL Server 2005 Mobile Edition"

type="Microsoft.SqlServerCe.Client.SqlCeClientFactory,

Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral,

PublicKeyToken=89845dcd8080cc91" />|||

Hmm...it looks like SQL Mobile Developer tools were not installed. Server Tools are not needed for you, they are meant for synchronization of SQL Mobile database with SQL Server. If you dont have Developer Tools, try installing the SQL Mobile Developer tools from the following location of your VS 2005 Disk: wcu\SQLCE\sqlmobile30devtoolsxxx.msi

The xxx in the MSI name stand for the locale, for english it would be 'enu'.

Let me know installing that worked for you.

Thanks

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||Dear Laxmi....

I also have the same problem and I tried to install the SQL Mobile Developer tools from VS 2005, but the location is not avalaible in the CD. I used VS PRo 2005.

Please help me because I have a project to write program for My Mobile Application that's need to connect to database.