How to convert a 3.1 database to a 3.5 database ?

  • Thread starter Thread starter Rainer Borchmann
  • Start date Start date
R

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
 
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.
 
Simon Hart said:
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.
Click to expand...

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
 
Back
Top