Pocket SqlGen allows you to choose a SqlServer, Access or ODBC database. It then reads the 'schema', and generates a create table statement for each table it comes across.

In addition, it generates the indexes for each table.

Pocket SqlGen is extremely flexible. Because you get the code written (eVB or .NET Visual Basic), you can change the code to do exactly what you need to do.

When Pocket SqlGen finishes, you have the code that generates a form which looks like this.

At the end of the Pocket SqlGen run, you can start an eVB project containing your new form automatically.

Then click on 'References', and check the 2 items shown below.

Enter a Database name, and click on ‘Create’. Your SqlServerCE datbase will be created, and optionally populated with data from your original database.

Use the power of the desktop tools to design and populate your database, and then PocketSqlGen to port it to your Pocket PC

A trial of Pocket SqlGen can be downloaded here. It runs for 30 days, but has a limit of only exporting the first 3 tables.

Pocket SqlGen costs $29.99, and includes 1 year of support via e-mail, and all upgrades and any bug-fixes, and can be purchased here.