Example workflow: Fix conversion issues in all code objects with Gemini assistance

Stay organized with collections Save and categorize content based on your preferences.

In this example scenario, you convert SQL Server code and schema where multiple code objects use the same SQL Server function that causes conversion issues. The rule-based conversion engine can't find a PostgreSQL equivalent for that function, so you need to fix the conversion issues yourself. To speed up the conversion process, you use Gemini conversion assistance to find out how to change the SQL Server code.

Your SQL code and schema are stored in the region where you create the conversion workspace. If you use assisted code and schema conversion with Gemini models, your code and schemas might be processed in other regions.

Learn how and when Gemini for Google Cloud uses your data.

In your Gemini-powered workflow, you follow these steps:

1. You open the details pane for one of the affected objects, and select Conversion assistant > Help me fix object conversion issues.

The Gemini pane opens.

1. In the Gemini pane, you click Insert suggestion and then save SQL changes.

2. You repeat the steps for every faulty code object.

   As you apply the code proposals, Gemini models learn the pattern and offer to add the fix to all objects with the same issue. The Review suggestions from Gemini dialog appears.

   

3. You click Review suggestions, and proceed to review suggested changes.

4. For each object, you click Accept code and exit the Gemini suggestions view.

Now the conversion issue fix is applied to all faulty code objects in your workspace.