Is there a way to migrate MSSQL database to sqlce?

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
8/8/2010 11:44:02 PM
Wei Li
Gravatar
Total Posts 125
View Posts

Is there a way to migrate MSSQL database to sqlce?

This question may sound ridiculous but I really like sqlce.  I have few small traffic sites and I really want to get rid of the mssql database. thanks

8/9/2010 8:40:01 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Is there a way to migrate MSSQL database to sqlce?

Hi Wei,

I don't know if there is a way to do it, I kind of doubt Microsoft put in the effort to make that possible since they are more interested in upselling to SQL server than having people downgrade to SQL CE. I would try using WebMatrix with a copy of the SQL database and then see if they have a way to migrate to SQL CE, but I kind of doubt it supports this.

Best,

Joe

8/14/2010 8:33:56 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Is there a way to migrate MSSQL database to sqlce?

Hi Wei,

I came across this tool, it says it can do importing, I have not tried it.

http://sqlcetoolbox.codeplex.com/

Best,

Joe

8/14/2010 11:42:31 AM
Wei Li
Gravatar
Total Posts 125
View Posts

Re: Is there a way to migrate MSSQL database to sqlce?

Thank you, joe.

I will give it a try and let you know the result.

 

wei

8/17/2010 6:53:53 PM
Wei Li
Gravatar
Total Posts 125
View Posts

Re: Is there a way to migrate MSSQL database to sqlce?

I have tried the tools you  suggested. I use the tools to generate the script, then import the script to SQL server management stuido to create the sqlce database. Everything is working fine and I can see the tables etc. When I run mojo with the sqlce database, it shows "The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method". Maybe the Management studio doesn't support sqlce 4.0 yet? Maybe I was doing somehting wrong?

8/23/2010 9:28:51 AM
andyc
Gravatar
Total Posts 116
View Posts

Re: Is there a way to migrate MSSQL database to sqlce?

Hi Wei Li,

I was reading through this thread and looking into this as an option on one of my sites and noticed this new post:

http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+ErikejBlogsAboutSqlCompactnetAndRelatedStuff+(Everything+SQL+Server+Compact)

Haven't tried to do it yet but if I do I will let you know.

Regards

Andrew

You must sign in to post in the forums. This thread is closed to new posts.