In this article I’m going to take you through the steps for using Amazon RDS with Entity Framework code first. I will not be covering any details related to Entity Framework. First you need to install AWS Tools for .NET. Then you will need to open up the AWS explorer from visual Studio View menu. Remember you need to have your account setup with Amazon Web Services. From this you can manipulate your AWS account.
So first I am going to create a database using the AWS RDS. Here I will be selecting the Amazon RDS (Relational Database Services).
In this blog post I would like discuss more about technologies that will aid and boost up the agile projects. I’m writing this article on the basis of Agile implemented on Scrum. So in agile scrum projects we do development, testing and release shippable products at the end of each sprint. It is a known fact that all these sprints are short, from 2 to 4 weeks, and the teams need to run as fast as they can to keep up the development work during the sprint to meet the objectives of the sprint, which is of course to deliver a tested shippable product that adds value to the end user.
For any project the infrastructure is very important. For the development team a development environment is highly important for execute their unit tests. Also for the testing team, a QA environment is important for execution of various tests such as, smoke tests, integration tests, regression tests, etc. If you are using an automated testing approach and the demand for a ready to use platform is very high where you can execute these automated tests.
I have been working with Amazon RDS for some time and always wondered that can we install CRM using Amazon RDS? This was a question haunting my mind for from the moment I have started exploring the features of RDS.
After setting up my AWS account I wanted to try this so bad and I did it. The main reason for going with RDS is the rich set of features provided by RDS. You can read more about these feature on the following link. Amazon Relational Database Services-Features
So I have set up an EC2 instance as bellow. Then I configured it to install CRM2011, i.e. configuring IIS and Active Directory services.
Then I have set up a RDS instance as bellow.
Make sure that the security group for the EC2 instance and the RDS instance is the same; otherwise you can’t access the RDS instance from the EC2 instance. At the present, it doesn’t support SQL server Analysis and Integration service as well.
After setting up the instances I have started the deployment of CRM2011, but it failed, because the RDS is not supporting SQL Server Reporting Services.
So I have found a workaround for this. After searching for some time I came across the following link to launch Optimized SQL server instance published by Microsoft. Microsoft optimized instance for SQL Server 2008 R2
So when we design the CRM2011 deployment I assume that we could use this particular image as a separate server which is running SSRS and point to RDS instance as the database. This solution will enhance the performance of the CRM Reports as the SSRS are running with dedicated resources. Or else we could use this as the backend SQL server for the EC2 instance. I’m going to explore these solutions in Part of this blog post.