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

RE: How to convert a 3.1 database to a 3.5 database ? by srhartone

srhartone
Thu Nov 22 12:26:00 PST 2007

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
Visual Developer - Device Application Development MVP
http://simonrhart.blogspot.com


"Rainer Borchmann" wrote:

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

Re: How to convert a 3.1 database to a 3.5 database ? by Rainer

Rainer
Thu Nov 22 13:57:25 PST 2007


"Simon Hart [MVP]" <srhartone@yahoo.com> schrieb im Newsbeitrag
news:9B7D9EDE-0AA2-43CC-B27D-E8D876F8729B@microsoft.com...
> 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