Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 890
  • Last Modified:

How to extract data from a SQL Server CE file

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
Philsh
Asked:
Philsh
  • 2
2 Solutions
 
James MurrellProduct SpecialistCommented:
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
 
PhilshAuthor Commented:
Unfortunately, I do not have a mobile device on which to load the SDF file. Therefore, that tool will not work.
0
 
James MurrellProduct SpecialistCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now