Data Migration

Copy tables, views, routines, triggers, and events from one server to another.

Where it is: Workspace › Tools › Data Migration

Open Migration from the workspace navigation bar. In the top header, expand the Target Server selector and choose one of the connections already configured in Calíope — only profiles saved in the Connection Manager are shown. Click Connect to establish the connection with the target.

Select the objects to migrate in the left tree (tables, views, functions, triggers, events).

Enable Replace at Target to include DROP IF EXISTS before CREATE statements, Export Data to include INSERT statements, and Skip FKs to disable FK checks during migration.

> If the target server you need does not appear in the selector, first add it from Connections and reopen Migration.

The object tree has a filter by name in its header: type part of a database or object name to narrow the list without expanding one database at a time. Objects are grouped by kind (Tables, Views, Routines, Triggers and Events) and each database checkbox selects or clears everything under it. Calíope fixes the migration order — tables, views, routines, triggers and events — so that every object finds whatever it depends on already created.

Keywords: migrate, migration, copy, move, target server, target connection, selector

Review the SQL that would be executed before migrating.

Where it is: Data Migration › Preview

Enable the Preview toggle before clicking the migrate button. Instead of executing, Calíope displays the generated SQL in the output panel so you can review or copy it. In Preview mode, connecting the target server is not required.

Keywords: preview, SQL preview, review before executing