Re: How to convert firebird stored procedures into postgresql functions

Поиск
Список
Период
Сортировка
От Martijn Tonies \(Upscene Productions\)
Тема Re: How to convert firebird stored procedures into postgresql functions
Дата
Msg-id 16CAAB074075437FBD0FDC95F764EC49@MARTIJNWS
обсуждение исходный текст
Ответ на How to convert firebird stored procedures into postgresql functions  (Elusai Soares <elusaisoares@gmail.com>)
Список pgsql-general
Hello Elusai,
 
I very much doubt there’s a tool for this, given that the procedural language isn’t the same, so you’re looking at converting syntax.
 
As far as I’ve seen PLPgSQL, it’s similar and it should be quite easy to convert Firebird PSQL to this language.
 
With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
 
Sent: Tuesday, May 17, 2016 2:56 AM
Subject: [GENERAL] How to convert firebird stored procedures into postgresql functions
 

Hi there :) I have an internship project that consists in migrate a Firebird structure and data to a PostgreSQL one. I have already gotten the migration of tables, primary and foreign keys (and other constraints), indexes and views to a PostgreSQL database.
But now I have 140 Firebird stored procedures. I need to convert them into PostgreSQL functions. My question is: is there any tool that could do this conversion? I have tried some tools such as DBTools Manager Professional, Full Convert and PostgreSQL Database Converter, but none of them is able to convert stored procedures.

 

I would like to find a tool because I have a little time to finish this activity manually, and I not even reached triggers...
Thank you all and best regards from Brazil :)

В списке pgsql-general по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Ascii Elephant for text based protocols - Final
Следующее
От: Johnny Morano
Дата:
Сообщение: Re: Increased I/O / Writes