how do I transform??sql server mobile edition database to sqlce2.0 format?

I have a database with sql server mobile edtion , and I want to depoly application to ppc with .net cf1.0, so , I must change format from sqlce3.0 to sqlce2.0.

Please.

There is no automated tool that will convert a SQL Mobile database to the earlier SQL CE 2.0 format. How did you create your SQL Mobile Database? If you did anything other than creating it by hand in Query Analyzer 3.0, you should be able to recreate that process and target SQL CE this time. For example, if you created the database using SQL DDL commands or via merge replication with AddOption.CreateDatabase, you can port that code to VS2003/CF1 and create yourself a SQL CE 2.0 database.

Darren

I really could not understand such requirement from your side. What is that compelling you to go back to SQL CE 2.0 and .NET CF 1.0?

If there are any issues with SQL Mobile 3.0 over .NET CF 2.0, we would be happy to help you out.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Thank you.

The reaseon is http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=360769&SiteID=1

I cannot find the exception, so, I had to try to override the whole application using vs2003 with .netcf`1.0 and sqlce2.0.

Hi apan,

I will surely take this up and would make sure that you get an answer to the above query.

We are really sorry to have you missed out in our forums.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation

Hi Apan,

Looks like Ilya Tumanov has replied to your post on .NET CF. Can you please check that?

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Everywhere, Microsoft Corporation