Ispirer Website
Ispirer Toolkit Overview
Free Trial
AI-Assistant in Ispirer SQLWays Wizard
Ispirer introduced AI-assistant feature in SQLWays Wizard that can be used to improve generated results of code conversion and save huge amount time on fixing possible issues for developers that works directly with the tool.
When AI-Assistant can be useful?
- Error Handling – now developers\experts can work with the generated code directly in the tool and solve all the errors with the help of suggestions from AI. And they don’t need to spend a lot of time by trying to identify the actual error and how to solve it. All they need to do is to ask AI to solve the error that appeared on import and send the generated code.
- Optimization Suggestions - After migration, the AI assistant can recommend optimizations for SQL code to improve performance or adhere to best practices in the target database.
- Code Refactoring - The assistant can identify and refactor redundant or deprecated SQL constructs to ensure the migrated code is modern and maintainable.
- Conversion Enhancements - The AI assistant can review and enhance automated conversions by adjusting syntax, optimizing queries, or addressing compatibility issues specific to the target database.
- Documentation Generation - AI can assist in generating documentation for the migrated objects, providing clear explanations on the logic implemented in migration objects, expected input and output results.
How to use AI-Assistant in Ispirer SQLWays Wizard
After running the migration process, some objects may fail during the import step. And you can see it in the “Migration Status” window.
Also near the import status there is edit button that allows you to work with generated code:
If you click on this button you will open new tab with code editor where you can see generated code, and output windows with the conversion and import statuses.
Also here work with the generated code, manually correct it and save.
And here you can run AI-Assistant by clicking Use AI button:
Will be opened window with AI settings where you will need to select AI type, model and provide API key:
Note: Currently Ispirer SQLWays Wizard support only Google Gemini AI. More AI providers coming soon…
After providing API key and clicking Connect button will be opened additional tab – chat with AI-Assistant. In which users can work with AI, for example to fix specific import error or check the code for improvements.
For example user can just ask AI to correct specific error in the generated code, add the generated code and send this request to AI: “please correct the error [Error_message] that appears in the code below [code_with_error]” AI will reply with the corrected code and user will need just to copy and paste the code in the editor and save it.
In such way user can correct all the objects and after correcting all the objects, run the import process once again and check that all objects were imported correctly and user can proceed with the testing process of the migrated code.
Related Topics
If you have any questions or face any difficulties, please contact our support team at support@ispirer.com