Creating a CE db at the desktop PC

Hello,

Is it possible to create a .SDF file at the develop machine?I want to write an exe which creates a sdf.So, my customer will be able to create a sdf and import this sdf to the device.

Thanks.

Hi xyzt,

Yes, you can create the .sdf either by writing an application (by calling the engine's CreateDatabase function, and scripting the schema), or with SQL Server Management Studio. You could then deliver that .sdf file to the device in your installation, or some other way.

Either way you do it, people seem to have the best results with scripting the database schema - I've heard the designers in SQL Server Management Studio need a little work.

Good luck!

Creating a 3.1 SDF from MDB

I am trying to populate a new SDF database to be deployed with my CF application, and am totally bummed to find out I have to manually code my own custom app just to import the data from the existing desktop DB with ado.net code.

I don't want to write code so that I can write code!

Custom apps to support the development of custom apps!

Jordan

I wrote a commercial application for this (you can try it for free for 30 days, though). You can download it from my company's website (look for Data Port Wizard).|||

Jo?o Paulo Figueira wrote:

I wrote a commercial application for this (you can try it for free for 30 days, though). You can download it from my company's website (look for Data Port Wizard).

I did try this app, (I was really lazy and desperately trying not to have to write any code :), but it kept saying it wasn't able to open the file. I did check "local", because the SDF was on my PC, not the PDA. I finally came to the conclusion that it did not support SQL Server CE 3.x, because 2.x was the only one referenced.

So I gave up and wrote a really quick and dirty app to transfer the data over. However, I've got to do a lot more transferring to do, and rather than modifying my data xfer app, I'd rather use your utility if I can get it to work.

Jordan

Creating .sdf file in PDA

Hi,

We are using VS 2005 with SQL Server Mobile Edition. We created the .sdf file on the desktop and added this file to our VS project and set the Build Action to content. Next we deployed our app on Symbol PDA which has Windows CE 5.0 as the OS. We followed the following steps:

1. Deploy the app.

2. Install .NET CF 2.0

3. System_SR_ENU.CAB

4. sqlce30.wce5.armv4i.CAB

5. sqlce30.dev.ENU.wce5.armv4i.CAB

6. sqlce30.repl.wce5.armv4i.CAB

Now I want to create a new .sdf file in PDA. So I open QA3.0 and type the create database command. But I get error:

You need to have a database connection opened in order to run this operation.

What could be the issue?

Regards,

Vilas

You cannot execute "CREATE DATABASE" unless you have an open connection, as stated. Use the Database icon with the green arrow at the bottom toolbar of the QA 3.0, then you will get a dialog where you create a new database.