SQL Server 2008 for SQL Server Compact Edition?

Question

I have some questions about SQL Server Compact Edition.

Now we use SQL Server 2008 and are developing in Visual Studio 2008 C # .net and linq to connect the database.

My questions:

• Can I change our database to SQL Server Compact Edition?
• What is the difference between the two?
• Are there any restrictions when using SQL Server CE, for example. database size, data size?
• Can the CE version support the entire data type with SQL Server 2008?

Regards,

Indie

Answer 1

In my experience using the compact edition of sql server.

(1) - sql-?

, :

sql- sql

Dataport

(2) ?

Sql- sqlser

(3) - sqlserver ce, , , ?

, - sql .

SQL Server Compact

(4) CE sqlserver2008?

Answer 2

Export2SqlCe: http://exportsqlce.codeplex.com