We needed to migrate our client’s current database which was Firebird to SQL Server (new DB). While the client’s landscape was complicated ( with roughly 250 tables and 200+ stored procedures and triggers) with given table structure and customized triggers and schemas, iSpirer utility helped to achieve our objective in a hassle-free way. We did evaluated lot of other utilities available but iSpirer was the only one which supported all triggers and schemas. It helped us to save a lot of manual efforts (migration of each SQL objects) and was a cost effective solution in the end. The team and support functions of iSpirer were very responsive to all our queries and collaboration with them was really a seamless experience. I would highly recommend their product (utility) for any database migration related projects. Thanking again Ispirer team for all the support !

Covers all elements during migrations including complex triggers and schemas

The utility was quite up to mark and was useful, no downside.

Ispirer is the best tool we found in the Database migration category. It does not just blindly do the pattern based migrations and rather applies good intelligence in doing so. With the awesome support from Ispirer team, we were able to customize some rules to our liking and it delivered perfect results. Using the flexibility offered by the tool, we were able to migrate databases with thousands of objects, with good speed through CLI options. The best part is that once the configurations are tried in test environments, we could simply breeze through our Production migrations without any extra efforts. The proactiveness of the Ispirer sales team and responsiveness of technical team made it a perfect DB migration experience. One thing which can be improved is speed of data migration, when BLOBs are present with high data volume. In general, for migration of couple of hundreds GBs of data (without strict downtime requirements) tool can be of help.

DB Objects conversion Easy to Install CLI Options Parallel Processing Value for money

Data Diffs can be added through some dashboard/reporting add on

Ispirer is a great tool for migrating databases. We used it to migrate large and complex database from SQL Server, Sybase to PostgreSQL. The migration process was smooth and easy, and the Ispirer support team was very helpful in answering our questions. We would definitely recommend Ispirer to anyone looking for a reliable and easy to use database migration tool.

Ease of use Ability to customize rules to fit the migration needs Very good customer support

No post migration reporting feature available in the tool

The experience with Ispirer has been exceptional. They are very cordial, prompt and professional. They readily attempt to check and eventually include your requirements in the tool. I experienced this in case of screen and SQL handling capabilities in COBOL to C# auto re-factoring.Overall, I found the team very well equipped with the needed technical knowledge.

The most important thing about this tool is it comes to help you in a requirement less in demand - COBOL to C# auto refactor. There aren't many tools in this space. This one works well with mainframe and AS/400 COBOL - within its current limits.

Not that I liked LEAST about this; however, it currently processes only business logic in COBOL. It doesn't take care of user interaction and reporting. Also, currently it is not equipped with SQL statements processing capabilities, e. g. - CURSOR processing.

Our migration from MSSQL server to PostgreSQL was facilitated by ISpirer. We are very happy and content with the support we got from ISpirer. We had some SQL Server specific constructions in our database, like the use of HiearchyIDs for instance, that simply do not exist in the PostgreSQL world. But ISpirer helped us work around this, by writing a customization that, in this case, leverages the use of the PostgreSQL function ltree. Another thing we encountered is that the migration was initially quite slow. It turned out we were not using the native mssql drivers in our DSN. After specific instructions from ISpirer the duration of a migration was reduced from 8 hours to 20-30 minutes. Because we have hundreds of databases that need to be migrated, automating the whole process was key for us. ISpirer helped us achieve just that, through their excellent tooling, customizations, and support.

The migration was quite slow when using the wrong ODBC driver. It could have been more clear that that would be the effect when choosing a DSN.