How to convert a 3.1 database to a 3.5 database ?

[Rainer Borchmann]

Yes, this is my question,
How to convert a 3.1 database to a 3.5 database ?
In the Step to Convert a Projekt from 2005 to 2008,
the Conversion wizzard cant convert the database.
How can i do it per hand ?
there is only 1 table in the database


bye
Rainer Borchmann

 

[Simon Hart [MVP]]

As you have discovered, the wizard will not do this for you. You need to use
the SqlCeEngine.Upgrade() method. ie something like the following should work
for you:

SqlCeEngine engine = new SqlCeEngine("Data Source=MyDB.sdf;");
engine.Upgrade ("Data Source=MyDB.sdf;encryption mode=platform default;");

This is a new method found in version 3.5 of the System.Data.SqlServerCe.dll
assembly.

 

[Rainer Borchmann]

As you have discovered, the wizard will not do this for you. You need to
use
the SqlCeEngine.Upgrade() method. ie something like the following should
work
for you:

SqlCeEngine engine = new SqlCeEngine("Data Source=MyDB.sdf;");
engine.Upgrade ("Data Source=MyDB.sdf;encryption mode=platform default;");

This is a new method found in version 3.5 of the
System.Data.SqlServerCe.dll
assembly.

Hi Simon,
Thank you, i will try this out. And it seems that will work as a good idea
to do
this programmatically

Bye
Rainer