index > SQL Server Everywhere Edition > Extracting Data from SQL CE SDF file

Extracting Data from SQL CE SDF file

Hi,

I have written application for Pocket PC it stores data on SQL CE database with extension .sdf. I have added data to the table and synchronised to the SQl server. I got the data, then unfortunately i deleted the data in SQL Server, I want to extract the data again from .SDF file of Pocket PC.

Is this possible if not then how can i get the data from SDF to SQL Server

Its very urgent and waiting for early reply to following mail address
prashanthk@mmi.ae

Regards,
Prashanth

naveen73

there are a couple of options Prashanth:

1. write a simple smart device program that connects to the database and table by table writes out the rows in those tables to CSV files on device. copy the CSV files to the server and import into SQL Server.

2. 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/

3. convert your SQL CE database to a SQL Mobile database and connect to it from Visual Studio 2005 or SQL Server 2005 Management Studio (then select out your records into another SQL Server DB).

-Darren Shaffer

.NET Compact Framework MVP

Darren Shaffer

Darren,
Can you tell me how to move an .sdf file from sql ce to sql server. I want sdf table data to append with SQL Server's existing data. Is it posible?

Thnx

Raj

Try without Commitment never succeeds

Raja Ram Singh

With SQL CE, you can't do anything with the .SDF file on your server. You need to get the data out of SQL CE while it is still on a device or emulator and transport the data (not the .SDF file) to your SQL Server. I listed the options for this - it would be very quick to simply write a program that selects out the data from SQL CE and saves it in CSV files. You can then copy the CSV files from your device to your server and then import the data into SQL Server directly from the CSV files. A third party tool like RemoteSQLCE will also handle this for you.

-Darren

.NET Compact Framework MVP

Darren Shaffer

Darren,

Thanks a lot for your suggestions, I was looking for tools to analyse sdf databases on a Windows XP environment for a long time!

- Jeroen Boiten

Developer @ www.wisdom.nl

Jeroen Boiten

Hallo, I'm Gabriel and I'm working with .NET 2005 and Pocket PC 2003.

I'm very very interested of first point, the one with the CSV export.Do you have an exemple ?

I'm very time stress.

Gabriel_M