4

I am trying to setup Sitecore 9(XP0) on premise with the SQL Server running on Amazon RDS for SQL Server. Unfortunately it fails when running the scripts to setup the databases: enter image description here

Is there anyone who had success setting up Sitecore 9 against an SQL in Amazon RDS? Any tips on how to get the scripts working?

Thx, Nicolas

1

You can't. At least I've not heard of a way.

What you can do, is to set up the databases on a local MS SQL Server, and then use SQL Database Migration Wizard to move the databases onto Amazon RDS.

A few links to step by step guides:

0

I've done some SC9 AWS setups, but have not used RDS as I don't believe it is officially supported by Sitecore. I would encourage you to reach out to Sitecore to make sure they will support your solution should you have the need.

In doing my own research and having bookmarked many topics, I did find this:

https://jeroen-de-groot.com/2018/07/19/deploying-sitecore-9-in-aws-rds/

Where I think this might be helpful to you is that it specifically addresses some database errors and its fairly recent (July 2018). Maybe this will help?

0

It is possible have done it. I had a few issues with SQL commands which return an error because a setting cannot be updated through SQL in RDS, but instead should be updated in the parameter group. I made a small change to the SQL included in webdeploy packages for this. Some more details about this can be found in my blog As mentioned in a different answer another option is to first install DBs in MS SQL and then move over.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.