How to extract data from a SQL Server CE file
Posted on 2007-11-20
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?