Philsh
asked on
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?
James Murrell
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/
ASKER
Unfortunately, I do not have a mobile device on which to load the SDF file. Therefore, that tool will not work.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.