Import from SQL Server Express into SQL Server CE

I'm using SQL Server 2005 Express as a database in my desktop application. My question is how to import from that database (which include table and开发者_如何转开发 stored procedure) into SQL Server CE.

Regards,

---

SQL Server CE doesn't support stored procedure.

Find out the comparison between CE and Express edition in the following link contains Local Data Feature Comparison.

http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc