Ispirer

Firebird to SQL DB Migration

주석: 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.

Best and most intelligent tool in the category

주석: 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 nGLFly Wizard 10

주석: 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.

Ispirer MnMTK is an outstanding migration tool like none other. I will use it time after time!

주석: I had been able to complete two separate migrations. I did try several other tools in the market place. We selected Ispirer MnMTK , for it was so much easier to use, and more effective with the total outcome we were looking for

장점:

I feel confident that the data being migrated will be transparent to the application. What I really appreciate is that Ispirer configured the tool for our specific needs. So when data has been migrated, the validation process is almost right where we needed it. But what is most important to me, is how quickly they were able to resolved some of our issues. Ispirer MnMTK tool is a great solution for those who require an efficient and quick database migration.

단점:

My dream is to see the actual export process go faster then what this tool does. Also, there are still few minor things that might require some manual work

PostgreSQL migration success

장점:

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.

The best tool for Database Migration

주석: I had to use SQLWays in the case of database migration. The project consisted of moving from SQL Server on Windows to PostgreSQL on Linux. I had to find the best tool for this particular migration because the data included BLOB types, and we couldn't afford to lose such sensitive information.
I had to test more than 5 tools, and in the end, the tool that caught my attention for its simplicity and ease of use was SQLWays.
Contacting representatives was easy, they answered me on the minute. [SENSITIVE CONTENT HIDDEN] has been especially kind and dedicated to my cause and not once has she been unavailable.
Best of all, given the size of my database, I didn't even have to buy the software. I have been authorized to use it for free. And thanks to them, now I can say that my migration took place in full transparency, without much human intervention. All that needed to be done was to authorize connections between the 2 database servers.

장점:

- Easy to use - Seamless migration - Recognized the database connectors - Big tables can be split into smaller size during export - The tool does the work it is expected to do. - Conditional migration (part of tables can be migrated) - Recognises tables, views, functions, stored procedures, etc.

단점:

The only thing I didn't like was the pressure of the license which is limited in time. But extensions are possible.

Db2 to Postgres conversion for procedure, functions and triggers

주석: Overall it was good experience using this tool and all our procedures, functions and triggers got converted successfully.

장점:

Ispirer has pre-assessment tool which really helps to get the exact idea about the conversion and the costing. The conversion tool is very easy to install and use. We had to do some customization and some changes in the tool as some of the procedures were not getting converted properly. Ispirer team was very helpful and providing fixes time to time.

단점:

It was all good and i don't have anything to add here.

Ispirer software and customer support was remarkable

주석: Very good experience. The company was responsive to our questions and issues and the software functioned well.

장점:

The conversion software simplified our Oracle to SQL project and reduced the amount of work we had to do. The company provided exceptional customer service and felt like an extension of our team.

단점:

The software was easy to install and Ispirer provide customizations where the tool was initially unable to convert some of our stored procedures.

What an incredible tool and team :) !

주석: I would like to talk about teams. They really listen and are very responsive, I am very pleasantly surprised. Several times, they quickly found solutions to my various problems. Whether in terms of implementation, or additional development.

장점:

Ergonomic and easy-to-use tool The ability to migrate from many different database, if necessary. The support Dynamic team

단점:

I don't really know, because everything was good, I really recommend them.

Ispirer SQLWays

주석: Technical Support are very helpful to guide.

장점:

Ispirer SQLWays was easy to use & support team are very responsive

단점:

No report of import results, some of our stored procedures and functions were not able to convert correctly. Oracle sequences also not converted correctly. License period may be too short for big data migration

COBOL to Java conversion

주석: We conducted a project for a major Japanese supplier to convert COBOL batch programs of about 400K lines to Java.The conversion was performed using the Ispirer tool, and the project proceeded with the policy of manually addressing the missing parts.Before the project started, whole conversion was performed in advance and problems were identified preliminarily, major problems were addressed by customizing the tool in advance.Without Ispirer's tool, it would have been impossible to complete the project within the eight-month time frame.Using Ispirer tool to convert COBOL to Java this time, we will never be converting COBOL to Java from scratch for similar projects in the future.I believe we will continue to use Ispirer's tools for similar projects in the future.

장점:

1. Ispirer Java library for COBOLThe tool converts to Java based on the Java library that Ispirer delivers with the tool for COBOL specific data types such as PICTURE type and other COBOL specific circumstances, so the accuracy of conversion is high.2. Extension of the tool (which is called customization)For example, in this project, the user was accessing Oracle using a special library that allows SQL access to the database to be coded as if it were a regular text file.But when rewriting to Java, we needed to rewrite it as JDBC access. This was necessary and we had some tool customizaions on this.This was very helpful because the tool was able to cover a large portion of this issue by customizing the tool.Ispirer was very helpful in consulting the conversion specifications for such customization, and was very quick and detailed in its response.

단점:

I think it is better to say that it is not a demerit but a point to be noted on the basic premise that a tool cannot convert 100% perfectly.In the case of conversion from COBOL to Java, performance problems may occur in the converted Java. This is largely due to the structure of individual programs, so it has to be handled manually.The secret of success may be to verify the performance at an early stage of a project.Other than this, I have no particular complaints.

Ispirer tool review on converting Oracle pl/sql to Teradata USP

장점:

1. Tool is very user friendly to operate and installation is quick and easy2. Customization is easy to meet the project requirements without affect the other functionalities 3. Good for simple code conversions

단점:

1. Complex functionalities (Ex. handling multiple cursors, variable data types, batch processing and dynamic SQLs and updates) are not addressed in code conversion which lead to more manual efforts2. Support team was expecting equivalent solution in Teradata for Oracle functions which were not converted properly in the beginning

Database migration

주석: 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

Sybase to MySQL Database Conversion.

주석: We are very pleased with the product, it saved us a lot of time.

장점:

The success rate of database objects conversion and customization requests.

단점:

We have no complaints about the product.

Use Inspirer for the migration from Informix to Oracle was our best choice and decision.

장점:

We like the facility to understand the migration process. We didn't need a complete expert experience to start to work with the software, making some exploration was enough to relation the concepts of oracle, informix and Inspirer. Another thing that we liked, was that the automation process save us a lot of time from our people, and of course that the process was online, reading the source information and processing at the same time. Definitively, Ispirer is a tool that should be considered for a migration process of this type.

단점:

Perhaps, the popullation of the data, because is in real-time, and you need a maintenance window to execute the process and wait until the end because there are no automatic resume option.

Experiences with Ispirer

장점:

Support requests are answered quickly and competentlyThe quality of the data migrations is very high

단점:

At times, a data migration project takes a long time because tables are unloaded sequentially

Sybase SQL Anywhere to MS SQL Server database conversion

장점:

The Assessment toolkit was very helpful. It provided an overall picture and the scope of the database conversion. It analyzed all objects including Views, Tables, Stored Procedures and so on within a source database. The SQLWays module worked well. It converted all data successfully to SQL Server. The process logged exceptions so we could either fix them before or after the conversion. Overall, it's a very good product and ispire customer support is exceptional!

단점:

The original version of the Assessment Wizard ran into an issue causing the error "Failed Objects (Not Parsed). However, the issue was quickly fixed by technical support. It ran successfully with latest version.

Purchased a licence for conversion of Banking grade MS SQL db to Postgres for challenger bank

주석: Significant reduction in database design and installation time.
Improved DB performance through improved code in the conversion process than our developers were achieving manually.

장점:

This product is the only one we tested to convert all of our database objects, including complex stored procedures with many nested function calls and even a variety of cursor loops etc. Some of our stored procedures are 2000 lines long. The Ispirer product dealt with them with ease. The Wizard interface and detailed logging was a big help in climbing initial learning curve. This product saved us countless hours in manual edits.

단점:

Seemed slightly slow to run but nothing overly problematic - for large batches of stored procedure and other object conversions it would still run in less than 30 min.

Great experience during project of migration SAP Hybris MySQL database to SAP HANA.

장점:

- Great customer support of Ispirer team who flexibly react to requested changes by providing new releases in a very short time - Wizard-based tool simple to use - With its 'driven flexibility' provides enough power to fit migration process - Detailed trace log - you know what is happening

단점:

Bigger table you export more RAM you need:)

We have used Ispirer in a big migration project from Informix to MS SQL Server

장점:

We had 1 or 2 minor issues with it but overall, it just works. All our data was successfully migrated across but even better, most of the business logic in the DB (ie stored procedures and functions) were migrated successfully with some minor adjustments that we need to make to handle input and output.

단점:

The handling of input and output to the various stored procedures and functions could be more versatile. Perhaps an option to select how these functions are called could be baked into the product. But overall it was something that we could manage ourselves quite easily so not much of an issue.

Great product at a great price.

주석: As you can guess, the over all experience is 5 out of 5 stars, really (no I'm not being compensated for saying that).

장점:

While I was more on the admin team, I can speak to the amazing customer service provided. I would not hesitate to recommend them.

단점:

Of course nothing is perfect, and that is the case here, but the tool is fantastic, and with the support we got, we were really pleased.

DB2 to MSSQL migration project

주석: Our experience was excellent. We took a complete database running on a very old version of DB2 and migrated successfully to a MSSQL databse. Customer support was very good when we have a few questions reagarding the use of the tool. Overall, very impressive!!!

장점:

This was THE ONLY tool we could find to allow us to convert a very old version of DB2 to a new MSSQL database. It is extremely easy to use, and also fast and accurate!

단점:

I have no "cons". This tool worked perfectly!!!

Migration specialist

주석: amazing tool would recommend any one to use this tool to mirgate data in multiple platforms.

장점:

Product was easy and user friendly team is very responsive and proactive in solving any issues we face during migration.

단점:

ODBC issue which caused hindrance during migration later Ispirer team provided solution.

Awesome Product.. Awesome customer support.. 100% success

주석: Really awesome for Cross RDBMS migration

장점:

We did migrate almost 13 application databases from PostgreSQL to MS SQL, with minimal downtime. The product is easy to use Really good customer support experience Price is good 100% success (OFFLINE migration with minimal downtime)

단점:

If there is an enhancement to do ONLINE migration, with some solid replication features, I'll believe your product will be ranking #1.

Excellent Product, Excellent Support

주석: I found this product online when I was faced with converting a client SQL Server Database to Oracle DB. When Oracle's migration tools failed miserably and with no support and very little to go on via online articles, I went searching for an alternative. Finding Ispirer's product, I downloaded the free trial, installed it and within 5 or 10 minutes I had already done a trial run. After speaking with Ispirer to get a license that would handle the full database, all I to do was solve my Oracle connectivity issues. With that in place, I ran the conversion and "bingo": all done. Very pleased with this product. Kudos to Ispirer for their brilliant design & implementation and a big thanks to their customer support people!

장점:

Gets the job done with a minimum of setup. Easy to use, consistent and reliable. Very intelligently designed and well implemented. A joy to use.

단점:

No complaints at all.