Solved

How to extract data from a SQL Server CE file

Posted on 2007-11-20
4
865 Views
Last Modified: 2013-12-27
I was given a .sdf file and asked to extract any data contained within. It is a relatively large file of 140MB. I do not have a PDA. I downloaded Microsoft's device emulator (v2). However, you cannot simulate adding any memory cards to the PDA and there is not enough space to load it in the emulator. I have been unable to find any software which would allow me to view or extract data from this file while on my regular desktop machine. I have Visual Studio 2008 beta loaded and I tried to access the data through that. It allows a SQL Server CE database type and I could browse to this file. However, I get an error stating that this is a SQL Server CE 1.0 or 2.0 file and I need to upgrade it to 3.5. Where can I get the "upgrade.exe" file that will do this? Any other ideas as to how to access the data?
0
Comment
Question by:Philsh
  • 2
4 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 20326331
there are third party tools that can connect to a SQL CE .SDF file on device and query their contents.  DesktopSqlCe is available for download here:  http://www.primeworks.pt/
0
 

Author Comment

by:Philsh
ID: 20327117
Unfortunately, I do not have a mobile device on which to load the SDF file. Therefore, that tool will not work.
0
 
LVL 48

Accepted Solution

by:
Mikal613 earned 250 total points
ID: 20327258
0
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 250 total points
ID: 20327289
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question