Friday, February 17, 2012

Export SQL Server 2k/2k5 DB to SQL Mobile 2k5?

Hi,

I'm currently doing a application for a smartphone which requires me to replicate the desktop version of a db which was running on SQL 2k. From my reading, it seems that i will need SQL server 2k5 Management studio in order to convert my desktop db to the SQL Mobile version? Is there any other way? For now, i only have the 2k5's management studio express which came with my VS 2k5. I only notice that the express version doesn't allow me to create a SQL mobile db.

Thanks!!

John

Express will not work. There is a great third party product that can do what you want:

www.primeworks.pt

Darren

|||

SQL Server Express can also create a SQLCe (Compact Edition) database. It's a bit more convoluted, but you can also download the SQL Server Mananagement Studio (Express) that can create it as well. I describe how to create databases as well as discuss replication in my EBook. See www.hitchhikerguides.net.

hth

No comments:

Post a Comment