SDF Database

[James Redclaff]

Hello

I have exported a database from SQL Server to a SQL Compact Database (SDF)
This database is workign on my device without any problems.

It is about 2.5 MB big. Everytime I am opening the Database with VS 2008,
the database gets blown up to 4.5MB and when I copy it over to the device,
it wont work anymore.

What could be the reason? Some Encoding problem?

Thanks

James

 

[Doug]

What version of sqlce?

 

[Ginny Caughey MVP]

James,

Did VS 2008 tell you you needed to upgrade the database? It sounds like that
may have happened and now you have a SQL CE 3.5 database. To work with it on
your device, you need the DLLs for SQL CE 3.5 too. Here's how to tell
programmatically the version you have:
http://blog.opennetcf.com/ctacke/2008/04/12/DetermingingASQLCEDatabaseVersion.aspx

 

[James Redclaff]

Hi and thanks for your answer

I've checked the database with Chris' code, it is V 3.5 before and after
opening in VS 2008...

It's really weird. Ok I can open it now in SQL Management Studio 2008, but
have to use sql statements there to alter it.

James

 

[Ginny Caughey MVP]

James,

Which version of SSMS 2008 are you using? I'm using CTP6 still, and I can
alter the schema ok, but I know of at least one person who had problems with
a later version that sounds similar to what you're seeing.