How to open sdf file(2.0) with sql server 2005 standard edition?

I have an embedded pc which runs windows ce 4.2. I have created an amplication which use sdf file 2.0 version. So i want to copy this database into Desktop PC and open it with Sql Server 2005. Should i upgrade this database? Will i have problems after upgrade?

[261 byte] By [SakellariouDimitris] at [2008-1-6]

«« Are "Windows Live Data" and "Astoria" the same or different?
»» how to target the file name with date variable

# 1

You cannot open SQL CE 2.0 SDF files in SQL Server 2005 Management Studio. The other issue for you is that the upgrade utility cannot convert a SQL CE 2.0 to a SQL Mobile database on a device running Windows CE.NET 4.2. My suggestion would be to copy your SDF file to a device that supports SQL Mobile (PPC2003, WM5, WCE5) and then run the upgrade utility. I'm not sure what you're trying to get done, but if it's just to open the database and extract it's contents, you could also use a third party tool to do so (www.primeworks.pt) without converting it to SQL Mobile.

-Darren

DarrenShaffer at 2007-9-28 >

top of Msdn Tech,SQL Server,SQL Server Compact Edition...

# 2

However you can use upgrade utility to upgrade your SQL CE 2.0 databse to SQL Mobile 3.0 database and then you can open that SQL Mobile 3.0 db file in SQL Server Management studio

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corp.

LaxmiNROMSFT at 2007-9-28 >

# 3

Where to get the upgrade utility?

FDSD at 2007-9-28 >

# 4

Look here for information: http://msdn2.microsoft.com/en-us/library/ms173006.aspx

ErikEJ at 2007-9-28 >

# 5

Alternatively, you can open .sdf file in VS 2005 by selecting File->Open->File(Select .sdf File)

Thanks

Meeta

MeetaKherdekar at 2007-9-28 >

# 6

I need to know. How can i open file sql Mobile (.sdf) by vb dot net 2005 & code control table (select , insert , delete)

on PC ?

Thanks

TingPalm

TingPalm at 2007-9-28 >

# 7

You cannot open SQL CE 2.0 files in VS 2005 or SSMS 2005. You can open SQL CE 3.x files is Server Explorer - Data Connections in VS 2005 and using SQL Server Management Studio (Express) SP2.

ErikEJ at 2007-9-28 >

SQL Server

SQL Server Compact Edition

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'How to open sdf file(2.0) with sql server 2005 standard edition?', No.1818980,Posted by SakellariouDimitris

How to open sdf file(2.0) with sql server 2005 standard edition?

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified