In this blog I will share with you my recent experience
with Sitecore upgrade, in a recent Sitecore upgrade I worked on I got the
databases from my client, I restored them in my SQL server 2012 and complete
the upgrade, I send the databases to client and asked them to restore to their database server; unfortunately they have SQL Server 2008 R2 and they don’t want to upgrade, So
what I should do?
After looking for solutions I found an amazing
tool that work like magic, SQL
Database Migration Wizard (SQLAzureMW) which help you migrate your SQL
Server 2005/2008/2012/2014 databases to Azure SQL Database.
Following are the steps of how you can move
your database from SQL server 2012 to SQL Server 2008 R2.
Download and run the version required, Select
the option Analyze/Migrate and your target Server
As you can see from the following screen shot:
Connect to your destination Database
See the following screen shot in which you
enter the destination SQL server information and the database that you will
copy to the other SQL server.
Adjust script generation settings, From the next screen click on Advanced and
update the following:
·
Target Database: SQL Server
·
From Tables/views options ensure that “Script/table
data” is set to “Table schema with data”.
·
From TSQL compatibility checks ensure
·
Database Engine Store Procedure” is set to True.
·
“Security Functions”
·
Security Stored Procedures
·
And system functions are set to true.
As you can see
from the following screen shot.
Then click
Next and check your selections, click another next.
You will be
notified the script will be generated as you can see from the following screen
shot.
The time to finish generating the
script will depend on your database size, you will get the following screen
when done:
Click next and enter destination SQL
server information and then click next, you will get the following screen,
after clicking yes you will get your database in the destination SQL server.
Hope it will help someone!
4 comments:
I like your blog post! It's very clear and the visuals are great. -Dana
Thank You!
Thanks for sharing this.,
Leanpitch provides online training in CSPO during this lockdown period everyone can use it wisely.
Join Leanpitch 2 Days CSPO Certification Workshop in different cities.
CSPO certification
As off late, the Synology migration assistant has become one of the most important Synology tools for almost everyone. TheSynology migration assistant toolas the name suggests, helps the users to migrate all their data, including the users’ favorite apps and files, from their old NAS to the newly bought Synology NAS. It is possible to use the Synology migration assistant tool by accessing the Synology DSM 5.2 web interface.
Post a Comment