AWS Schema Conversion Tool Reviews & Product Details

AWS Schema Conversion Tool (SCT) is a product to help migrate business from on-prem to cloud or cloud-cloud. This tool helps to identify the schema and complexity of database/ Data warehouse. This tool can migrate between various rdbms like oracle, Mysql, and Postgres along with migrating data to S3 and redshift. Review collected by and hosted on G2.com.

I didn't find any difficulties with this tool. Rather this tool helped me a lot while migrating on-premise oracle data warehouse to Redshift that too in PB scale. I don't have any dislike for this tool. Review collected by and hosted on G2.com.

Wide support for databases and providers is the best part and shifting is completed seamlessly without manual intervention and without worrying much on queries and Schema while shifting. Review collected by and hosted on G2.com.

Most of the times it works great but several times I need to look into manually in order to get a task completed this is the negative point and the point which I disliked. Review collected by and hosted on G2.com.

The best part is the convenience being offered and helps to save a lot of time as migration from one cloud provider to another is done with a few clicks and efficiently as we need not to look for scema key by key and mostly SQL databases are being supported. Review collected by and hosted on G2.com.

The part which I disliked is no support for No-SQL Databases as it can't be used on MongoDB, adding up limitations, and several times indexing and procedures are done manually and could be automatic. Review collected by and hosted on G2.com.

It is a time-saving software with great data analytical features available. Moving db from one server to another has been more accessible with this software, which makes workflow more manageable. Stores and protects all the data at one place, fully encrypted end to end. Best and easiest way to convert OLTP formate to any other formate you require or you use. Review collected by and hosted on G2.com.

The feature of transferring files is sometimes slower when trying to import or transfer multiple files simultaneously or larger files. There are less automation features in this platform. Review collected by and hosted on G2.com.

From my usage, I like that we do need not to put many efforts for getting things done in lesser time and most of the SQL Database Service Providers are supported along with it, Auto Scan Feature is the best part of it. Review collected by and hosted on G2.com.

I dislike that it do not support NOSQL Databases which I feels is lacking and adding a limitation, another thing which I faced was many Datatypes are not recognised or may be supported that thing is done manually that needs to be improved. Review collected by and hosted on G2.com.

Saves a lot of resources for manual migration processes, esp. for things like automatically generating migration scripts and doing machine conversions. Can typically get you 95% of the way to a full migration with little effort. Review collected by and hosted on G2.com.

Getting to the extra 5% can be very difficult IF you have very specific requirements or quirks of your source db that you are relying on. Documentation and support for trouble shooting could be much better, esp. since this is a more "niche" and newer product without a lot of documentation out there (e.g. on stack overflow) Review collected by and hosted on G2.com.

AWS Schema conversion Tool help's us to migrate on premises database to the cloud or between different databases like Oracle, MYSQL, PostgreSQL etc. It analyses the database schema and suggests the code changes and generates the automated scripts. Review collected by and hosted on G2.com.

It may require some manual coding effort to optimise the migrated database for best performance. It may not support every possible database platform which could be a limitation for some users. Review collected by and hosted on G2.com.

I felt the software is easy and simple to use and also saves time while shifting from one database provider to another easily with an interactive User Interface and support for most of the database providers. Review collected by and hosted on G2.com.

NoSql Databases are not supported by this tool Also I dislike that many times some parts are to be done manually as they are not automatically detected all this is the something that could have been better Review collected by and hosted on G2.com.

Converting my DB schema from one DB engine to another one, its really easy to make it and migrate our on-prem DB to the AWS RDS DB without data loss and AWS provides a wide range of DB engines, which covers most of our preferences Review collected by and hosted on G2.com.

There are some limitations like can't migrate our on-prem MySQL or Postresql Databae to DMS because On Prem DB is a relational database which has all constraints like indexes or primary keys something like that. Review collected by and hosted on G2.com.

AWS Schema Conversion Tool is a powerful tool that can make database migration faster, easier, and more efficient. It automates much of the manual work involved in database migration, making it easier and faster to migrate your database to the cloud. Review collected by and hosted on G2.com.

In order to use this tool, users need to have an AWS account, which can be a barrier to entry for some users who are not already using AWS services. It also has limited Support for Some Databases which are not that popular. Review collected by and hosted on G2.com.