We have taken that as a Platform as a Service. So, how we are running here, we just migrated whatever database instance in the rack was there to AWS. It was an "as-it-is" migration.
For data, we tried to use SSIS to transfer the data from the patch to AWS.
The main thing why people are going behind AWS is the cost.
For example, on the current project, I am working with an insurance company. So the basic thing is they want to accomplish whatever add-on services AWS provides, but they don't want to go all in a single step. Plus, they want to see what the platform is. Then they look step by step. So, it is an incremental adoption kind of thing.
So, we are helping and enhancing our knowledge of that.
As a solution, the better thing is if more platforms come with direct compatibility, like connecting to different data sources.
The basic problem I faced the most was while transferring and reading data from Excel. So, one time, I found that all the components I had declared in my scripts were able to take it.
And after some patching happens, it is not able to support that. Again, we need to update the version of Excel. So, it's not like a plug-in type place where you have done the solution and are confident that it will work. So, this is an area of improvement.
If we look at Microsoft products, most things look or are plug-and-play. For example, if you are using storage as a service, we need to go for CLI commands. So, those types of stuff that's not as easy as using a Microsoft product, like DDoS, that level of easiness is not there.
In the project I am in, we migrated from SQL Server from RAS to AWS recently.
I would rate the stability a six out of ten. We had some issues with stability.
I would rate the scalability an eight out of ten. It is able to scale up and fulfill requirements.
The only thing weakness is compatibility. Like, once you program and forget it, it's not that type of thing.
I faced some problems while patching; new things come up, and sometimes old things don't support, causing a bit of a headache for me.
We have a big-sized company with various clients.
Experience with customers and support was good. I got a good response. It was not a delayed response, or it was not that I had to go back to the multiple times for the issue. It was not there.
Overall, I had a good experience with the support.
The initial setup is simple. Not that much complex.
The pricing is neither high nor low. It is value for money. Moreover, the facilities or the add-ons they give are good.
Overall, I would rate the solution a ten out of ten.