SQL Server CE instead of SQL Server Express

When creating a new ASP.NET MVC application in VS2010 you get Account (Simple Membership Database) database in SQL Server Express format.

Since I have problems with database migration / configuration on my remote host I decided to switch to SQL Server CE.

Question: how can I migrate from SQL Server Express to SQL Server CE? Tried to re-create tables from SQL Server Express in SQL Server CE but my approach to create names starting with 'dbo.' i.e. failed (used CompactView software)

CREATE TABLE [dbo].[webpages_UsersInRoles]
(
    [UserId] [int] NOT NULL,
    [RoleId] [int] NOT NULL
);

So I created tables without 'dbo.' and it does not work.

Question: what is the best approach to migrate a simple membership database from SQL Server Express to SQL Server CE?

Question2: Is migration from SQL Server Express to SQLite easy?

Thank you!

Copyright Notice：Content Author:「Jacek Wojcik」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/27678188/sql-server-ce-instead-of-sql-server-express