|
From: Robert M. <rob...@gm...> - 2010-11-30 22:12:55
|
Hello, A kind person (Andreas) was nice enough to send along this English translation of your questions. I will endeavor to answer them (in English, of course) and hope my answers will be helpful to you. Here goes: > I would like to develop a SQuirreL plugin to compare metadata of two > different databases. There is a plugin that you could use as a starting point and it is called the DBDiff plugin. It will allow you to select and compare tables in two different SQuirreL sessions. It uses JDBC and currently only focuses on column metadata. > To support a migration project from a Informix database to Oracle. > From my point of view, the comparison of the metadata information of > the two databases should > be the first step of validation of the migration. > The following questions arise: > * Can the task be done with a SQuirreL plugin? To some degree, I would say yes. See below. > * Does SQuirreL provide functionalities that support me in this task in contrast to plain Java and JDBC? We use a Hibernate dialect style approach to extending plain JDBC to produce SQL that is tailored for specific databases. For example, JDBC doesn't present a way to definition of a view, but most databases support querying the data dictionary to extract this information. Our dialects implement an API in which getting a view definition is supported. Our dialects also provide SQL for making DDL changes such as adding/dropping columns, indexes, foreign and primary keys, etc. > * Is a SQuirreL based solution already available for my problem? Along with the DBDiff plugin, there is the Refactoring plugin which allows you to perform common refactorings to bring the schema of the target database in line with that of the source database. Finally, there is the DBCopy plugin which will allow you to copy records from the tables in one database session to like tables in another. Mostly, if you are not using database-specific logic (stored procedures, triggers), then database migration is possible, but a somewhat manual process. For example, DBDiff can tell you table differences, but you need to then use the refactorings to synchronize the schema. It would be nice to automate this so that it can produce a single alter script. However, database-specific logic is always going to be a very challenging problem. 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). > ------------------------------------------------------------------------------ > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > Tap into the largest installed PC base & get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Squirrel-sql-develop mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop > |
