oracle-databasepostgresqldatabase-migrationsquirrel-sql

PostgreSQL to Oracle migration through drag and drop in SQuirreL

I need to convert the structure of PostgreSQL databases to Oracle.

I use SQuirreL SQL Client 3.3.0 with MDI interface and I opened two sessions: one for PostgreSQL, another for Oracle. MDI interface allows to move objects between schemas (drag and drop).

enter image description here

But when I move objects between schemes, I get an exception:

[AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.gui.dnd.FileEditorDropTargetListener - handleUriListFlavor: no support for text/uri-list data flavor

What does this error mean and how can I use SQuirreL SQL Client for migration of table structures?

Solution

  • Great! It works. But only in the version of SQuirreL SQL Client 2.5.

    enter image description here

    Ie by using simple drag and drop, you can make database migration.