This blog post will guide you to migrate Sitecore SQL Server databases to Amazon RDS.
Unfortunately, you won’t be able to directly use the MDF and LDF files in AWS at the moment so to migrate SQL database to Amazon RDS we are going to use SQL Azure Migration Wizard. Follow below steps for migration –
- Before starting migration please make sure
- You are able to connect to Amazon RDS. To check it you can utilize SQL Server Management Studio
- Down SQL Azure Migration Wizard tool
- Extract the downloaded zip file and open SQLAzureMW.exe file.
- Start migration
- Choose Source database
- Choose action
- Once source database is selected then in this step select an option named as ‘Script all database objects’. This option can enable to do the complete migration of the database. But if you don’t want to migrate entire database then you select an option that says ‘Select specific database objects.’ Please see below image
- Once source database is selected then in this step select an option named as ‘Script all database objects’. This option can enable to do the complete migration of the database. But if you don’t want to migrate entire database then you select an option that says ‘Select specific database objects.’ Please see below image
- Create SQl script
- Select Destination Database
- Final Step and Review Target server Response
- Once you hit next in above step migration will start and you can review result of migration in this step. You can now connect to RDs database using your SQL Server Management Studio and check all the migrated data. This tool will save a lot of time.
You may see below errors in migration report
StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] — sp_helpuser is not supported in current version of Azure SQL DatabaseTo make sure there is no problem in migrated database because of above error I recommend connect to RDS database and make sure Stored Procedure aspnet_Setup_RemoveAllRoleMembers is there.
- Once you hit next in above step migration will start and you can review result of migration in this step. You can now connect to RDs database using your SQL Server Management Studio and check all the migrated data. This tool will save a lot of time.