Reading time: 5 min

Published September 10, 2024

Today is the day X for Ispirer Systems. We are excited to introduce the built-in AI assistant powered by Gemini, now available directly within our SQLWays Wizard interface.

From September 10, 2024, the AI-supported SQLWays Wizard is available to migrate your databases even faster. In order to test our AI-assistant, book a demo with our experts. They will demonstrate all the capabilities of our AI assistant and provide you with personalized SQLWays Wizard. If you already have SQLWays Wizard, contact your business manager for upgrading the SQLWays version.

How can an AI assistant be helpful?

5 use cases AI assistant can help you with during migration


SQLWays Wizard use cases

Ispirer AI assistant will help our clients with the following tasks:

  • Error handling. Users can now address errors directly within the tool with the help of AI suggestions. Instead of spending time identifying and resolving issues manually, simply ask the AI to fix the error that appears during import and submit the updated code. Optimization suggestions. After migration is complete, the AI assistant offers recommendations for optimizing SQL code. These suggestions can enhance performance and ensure adherence to best practices in the new database.
  • Code refactoring. The assistant identifies and refactors outdated or redundant SQL constructs, ensuring that the migrated code is modern, efficient, and easy to maintain.
  • Conversion enhancements. The built-in assistant reviews and improves automated conversions by adjusting syntax, optimizing queries, and addressing compatibility issues specific to the target database.
  • Documentation generation. AI helps generate comprehensive documentation for the migrated objects, providing clear explanations of the migration logic, expected inputs, and outputs.

80% time savings for post migration refinement

According to the Ispirer experts, the Ispirer AI-assistant will save 80% of your time for post migration optimization that would normally be spent correcting the results generated by the conversion tool. With this feature, migration experts can now ask the AI to identify errors and provide a correct solution. The user only needs to test the provided solution and apply the corrected code. In the case of Ispirer SQLWays Wizard, users will just need to run the import.

How to use it? Stay tuned for a detailed guide on using the AI assistant that will be live this month on our blog.

AI time savings, September 2024

Alex Kirpichny

Alexander Kirpichny

Chief Product Manager, Ispirer Systems

“This latest AI-powered update is a game-changer for our customers. It not only accelerates post-migration refinement but also enhances overall project agility. While the tool handles the core migration tasks, AI addresses minor errors and optimizes generated code to eliminate human error. This ensures seamless migrations and reduces operational costs, all within a short timeframe.”

Code security as the top priority

At Ispirer, we are committed to upholding our values of client code security and privacy. We ensure that our tools and processes maintain the highest standards of data protection.

  • Optional use of AI assistant. The AI assistant is an optional feature within the SQLWays Wizard. You can choose to enable or disable it, based on your specific needs and preferences.
  • Activation only after migration completion. For added security, the AI assistant can only be activated after the initial migration process is fully completed. This ensures that the AI is only used in a controlled environment, preventing any premature access to sensitive data.
  • No access to source or converted code. The AI assistant does not have direct access to the client's source code or the converted code. It operates in a separate layer, providing guidance and suggestions without ever seeing the original or transformed data.
  • Client-controlled data sharing. Customers use their own Gemini account credentials to interact with the AI assistant. This ensures that any communication with the AI is fully authenticated and traceable. Only the client decides which specific pieces of code, if any, to share with Gemini for analysis.

Ready to elevate your database migration? The latest version of our tool is now available for testing. Schedule a call with our experts to explore its capabilities and receive your customized version tailored to your needs.