CODEWITHSUNDEEP
postgresqlfirebirddatabase-migrationfirebird1.5
Afrog Nuñes
Afrog Nuñes

Reputation: 558

Triggers in migration from Firebird to Postgresql

I need to migrate a database from Firebird 1.5 to PostgreSQL (version 8.4, that's the version installed in the server of my customer. It's not under my control so I can't update).

I used the trial version of the EasyFrom program, and it worked for the tables, but it seems that the triggers were not migrated (I used the select * from pg_trigger command and the triggers I wanted to migrate were not shown; also in pgAdmin, in Schemas > Public > Tables > specific_table > Trigger there's nothing)

Is there a program or a simple way to migrate the triggers? Or do I need to manually create the trigger migration?

Upvotes: 0

Views: 668

Answers (1)

Mark Rotteveel
Mark Rotteveel

Reputation: 108994

Short answer: no.

Long answer: every database has their own dialect for triggers, and their own quirks you need to take into account. Although it could be possible to translate this automatically, there are - as far as I am aware - no tools that do this for you.

In other words: you will need to do this yourself.

Upvotes: 2

Related Questions