Welcome back! This is Part 3 of our post series of moving a website out of WordPress and into Sitefinity CMS. In this post we’re covering Migration Method 2: Database Transfer.
MIGRATING A WEBSITE VIA DATABASE TRANSFER
WordPress stores just about everything in its database – blog posts, pages, etc. If your site uses ecommerce (you take product orders on it), then this method is preferable. Why? Because transferring the WordPress database into Sitefinity preserves the order records stored there.
If your site does not use ecommerce (or uses a third-party platform), then we recommend using Method 1. DO NOT use both Methods at the same time; you run the risk of duplicating your content in Sitefinity. Which is messy and a pain to clean up.
WordPress uses the MySQL Database Server by default. Sitefinity’s default is Microsoft SQL Server. Even though these are different database servers, they both use SQL. Transferring the site’s content, is a matter of exporting the database from WordPress and importing it into Sitefinity.
One way to do this is via the SQL Server Migration Assistant (SSMA).
However, it’s not quite that simple. You must set up a new site instance in Sitefinity beforehand. You may need to use an API in order to arrange a clean import of the content. Some advice for that is in this Sitefinity forum thread.
And most importantly – have a professional database administrator do the transfer! We’re talking about critical data here. Consult a professional so your site comes out looking clean and complete.
This site claims to transfer WordPress sites whole-cloth into a Sitefinity CMS instance. I have no reason to doubt this, but I haven’t been able to verify their tool’s effectiveness. I present it here so you know of the option, but I can’t recommend it due to no personal experience.
After Migration, Clean Up
Now you’ve performed the migration, whichever method used. What’s next? Well, depending on how complex the site was before, you may have some clean-up work to do.
In Sitefinity’s Pages, Content items and Blogs, make sure you:
- Have all the content you want (including images, video & downloadable files)
- Have the page structure you want (may need to create this pre-migration)
- All user accounts are in place & active
- Have the templates properly configured
(Sorry, plugins & themes don’t translate. But Sitefinity has custom modules and themes available too.)
You may not need to do any clean-up – if so, congratulations, you had a perfect migration! For the rest of us, be prepared for a little tidying.
As I said before, migration’s not easy. But it’s a worthwhile effort, if your site needs more features and better security. You’ll be moving into a business-class CMS with slick features you can take advantage of as you grow.