Microsoft MVP - Orchard CMS Developer

RSS Twitter Google+

Orchard Web Developer - David Hayden

I develop exceptional websites based on Orchard CMS. I create Orchard Themes, custom Orchard Modules and Widgets, and convert WordPress and HTML Templates to Orchard Themes.


Contact Me: david@sarasota.me

Recent Links
Mobile Web Development for iOS and Android with Adobe Shadow Link Mobile Web Development for iOS and Android with Adobe Shadow
ASP.NET MVC 4 AllowAnonymous Attribute and Authorize Attribute Link ASP.NET MVC 4 AllowAnonymous Attribute and Authorize Attribute
Fixing the Orchard Gallery Feed Error Install Package Failed Link Fixing the Orchard Gallery Feed Error - Install Package Failed
Creating Custom 404 and Error Pages in Orchard CMS Link Creating Custom 404 and Error Pages in Orchard CMS
Conditional Attributes in Razor View Engine and ASP.NET MVC 4 Link Conditional Attributes in Razor View Engine and ASP.NET MVC 4
Display Edit Links Around Content and Widgets in Orchard CMS Link Display Edit Links Around Content and Widgets in Orchard CMS
Converted ASP.NET MVC Website to Orchard CMS Link Converted ASP.NET MVC Website to Orchard CMS
Orchard Data Migration Classes Automatically Update in Orchard 1.4 Link Orchard Data Migration Classes Automatically Update in Orchard 1.4
What's News in Orchard 1.4 Link What's News in Orchard 1.4
ASP.NET MVC 4 Bundling and Minification of CSS and JavaScript Link ASP.NET MVC 4 Bundling and Minification of CSS and JavaScript
Tweets
Quick tip on using WorkContext.CurrentTheme and Html.ThemePath in Orchard CMS. http://t.co/9M8c4ke9 #orchardcms
JetBrains released dotPeek 1.0, their Free .NET decompiler and assembly browser. http://t.co/O65OqcLQ
Amazon Web Services now supports SQL Server and .NET Applications. http://t.co/nNZSd9Z9
After many hours of KoA and Skyrim, I need to find a new RPG for me and the kids. Thinking an older one - Dragon Age: Origins.
Orchard 1.4.1 Released! Download: http://t.co/KDphWq7U Blog Post: http://t.co/MnVvVhHh #orchardcms
Donating my remaining 103 .NET and Software Development books to local public library today. Hope they make a difference!
tags

Migrate Orchard Database from SQL Server CE to SQL Server using WebMatrix

Mar 26, 2011 sqlserver webmatrix David Hayden

One of the absolute greatest things about Orchard CMS is that it supports SQL Server Compact Edition ( SQL Server CE ). SQL Server CE is a free database solution for small business websites. With Orchard CMS and SQL Server CE, small businesses can have an affordable website that can run on inexpensive shared hosting in no time.

Even better is that if your Orchard Website outgrows the needs of SQL Server CE, which may not be likely, you can easily migrate SQL Server CE to SQL Server Express or SQL Server. And when we say EASY, we really mean EASY.

In fact, the free Microsoft Web Development Tool, WebMatrix, has a nice wizard that will uprade SQL Server CE to SQL Server. Open your Orchard CMS Website in WebMatrix and literally just click on the Migrate Button to transfer your Orchard CMS Database from SQL Server CE to SQL Server. Provide the name of the server, any SQL Server Logon Credentials, and then watch WebMatrix upgrade your Orchard Database to full-fledged SQL Server.

 

Migrate SQL Server CE to SQL Server - Orchard Database

 

Of course WebMatrix won't automatically update your Orchard Website to use the new SQL Server Database. Once you update your Orchard Database to SQL Server, you will need to properly configure your Orchard Website to use the new database. If you are not an Orchard Web Developer, I recommend you hire an Orchard Website Developer and have them backup your existing Orchard database, migrate the existing Orchard Database to SQL Server, and then properly configure Orchard to use the new database.

Although I expect that WebMatrix will easily convert to SQL Server CE to SQL Server nine out of ten times without any problems, we have encountered problems during the migration that has caused WebMatrix to unexpectedly quit due to an unknown error. Although we haven't experienced it yet, you could experience database corruption or worse due to an unexpected problem, so always backup your existing Orchard database first.

The key here is that you can start with a free database like SQL Server CE for your Orchard Website and then easily migrate later if you need the services of SQL Server! The Microsoft WebMatrix Developer Tool is just one way to migrate your existing SQL Server CE Database to SQL Server.

If you need help, please contact us.

TOP! © Copyright Sarasota.me
FOLLOW ME:
TWITTER