Converting Desktop Engine to SQL Server 2005

I have got SQL Server Desktop Engine running with 2 database and I need

to install the evaluation version of SQL Server 2005 instead. A

straight upgrade does not seem to be possible. Does someone know if

backing up the databases, uninstalling the desktop engine, installing

SQL Server 2005 and then importing/restoring the databases would be an

option to look into?

Here is an article on Upgradeing MSDE to SQL 2005 Express, you could follow this example then it is an easy upgrade to the Full SQL 2005 Product.

sqlsql

Convert from .sdf file to .mdb file

Hellow

I have an application that builds a .sdf Sqlq Server Compact Edition file I want to view the file on a desktop computer How can I do it ?

If there is no simple way to do this how can I write a C# application to convert the .sdf file to .mdb file so I will be able to use Microsoft Access to view it.

Thanks

Ofer

You can connect to your SQL Compact Edition database using SQL Server 2005 Management Studio or Visual Studio 2005 SP1. If you need to convert from .SDF to MS Access (or vice-versa), check out the Data Port Wizard tool from one of the other MVPs, JP Figueroa:

http://www.primeworks-mobile.com/

Regards,

Darren Shaffer

|||

You can also try SQL Server Express edition if you do not have SQL Server 2005.

Cheers

Jeba