asked on

SQL Express 2008 Export To SQL Server CE 3.5 or 4.0?

I've never worked with CE, but it seems to be a nice alternative to it's big brother.

Q. How do I export existing SQL Express 2008 database to To SQL Server CE 3.5 or 4.0?

Q. Are there any restrictions changing to CE? (db size, etc...)

SOLUTION

BartVx

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mark Wills

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pointeman

ASKER

Great support, more questions:

>>Compact edition doesnt really need any installs. Just copy a few files and you are up and running.
1. So can I copy-n-paste my existing MS SQL CE (C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v3.5) to...

USB drive?

Tablet (Android)?

Netbook?

pointeman

ASKER

>>To migrate your database, check out this tool: http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx

Q. Will the Code Project utility work for SQL Express 2008 & CE 4.0? (Seems to work on SQL 2005 & CE 3.5)

ASKER CERTIFIED SOLUTION

Mark Wills

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pointeman

ASKER

I'm a C# .NET developer, but in this case not developing software. I'm trying to get our code library 'Code Warehouse' http://www.xcca.com/ moved from SQL Express 2008 to CE 3.54.0 for portability sake. Thought about moving toward a windows tablet. We used to run Code Warehouse on .MDB. but our Windows Vista upgrade prohibits this. So we run on Express 2008. That's what wer're trying to accomplish.

:)