Re: [Squirrel-sql-develop] Plugin zum Testen einer Informix->Oracle Migration

[Victor O. <vic...@gm...>]

Without any guarantee for accuracy:

He wants to write a plugin which compares the metadata of two
databases. Background: migration of a Informix DB to Oracle. First
migration step should be, in his opinion, to verify if the metada of
the two databases match.

He asks following questions:
* could such task be done with a SquirrelSQL plugin?
* does SquirrelSQL offer functions wich ease the work (compared to plain JDBC)?
* does a plugin already exist for such tasks?

He sends thanks in advance and greets from Frankfurt (Germany).

;-)


On 2010-11-30, Robert Manning <rob...@gm...> wrote:
> Google translate ... save me!  Gerd ?
>
> Rob
>
> On Wed, Nov 17, 2010 at 12:58 PM, g-fft-frs-ta
> <g-f...@co...> wrote:
>> Hallo zusammen,
>>
>> ich möchte gerne ein Squirrel Plugin schreiben, welches Metadaten zweier
>> Datenbanken vergleicht.
>> Der Hintergrund ist, dass ich wir momentan unsere Informix Datenbank auf
>> Oracle migrieren. Der erste Schritt zum Validieren der Migration, wäre
>> meiner Ansicht nach, zu Testen ob die Metadaten beider Datenbanken gleich
>> sind.
>>
>> Ich stelle mir jetzt folgende Fragen:
>>
>> *       Wäre es denkbar diese Aufgabe mithilfe eines Squirrel Plugins zu
>> lösen ?
>> *       Bietet mir Squirrel Funktionalitäten die mir die Arbeit
>> erleichtern (im gegensatz zu plain Java/JDBC) ?
>> *       Gibt es schon Squirrel-basierte Lösung für mein Problem ?
>>
>> Danke im Voraus und viele Grüße aus Frankfurt:)
>>
>> Reda El-Jazouli
>>
>>
>> This e-mail is confidential and is intended only for the person to whom it
>> is
>> addressed.  It may be privileged and should not be read, copied or used
>> by
>> anyone other than the intended recipient.  If you are not that person, you
>> are
>> not permitted to make use of the information and you are requested to
>> notify
>> the sender immediately that you have received it and then destroy the copy
>> in
>> your possession without disclosing its contents to any person.
>>
>> Commerzbank AG may monitor outgoing and incoming e-mails.  By replying to
>> this
>> e-mail you consent to such monitoring.  We believe, but do not warrant,
>> that
>> this e-mail and any attachments are virus free, but you must take full
>> responsibility for virus checking.
>>
>> This e-mail was sent either by Commerzbank AG, London Branch, or by
>> Commerzbank
>> Corporates & Markets, a division of Commerzbank AG.  Commerzbank AG is a
>> company incorporated in the Federal Republic of Germany and registered in
>> England (registered number FC008139, place of business 30 Gresham Street,
>> London EC2V 7PG) and is authorised by Bundesanstalt fuer
>> Finanzdienstleistungsaufsicht (BaFin) and authorised and subject to
>> limited
>> regulation by the Financial Services Authority (FSA).