Re: [Squirrel-sql-develop] New Plugin Proposal

[robert <Rob...@co...>]

Hey,

Keith Mashinter posted a link to opendbcopy which according to the 
description
seems to solve the problem I've described in my previous email.
(http://sourceforge.net/mailarchive/forum.php?thread_id=7487032&forum_id=3124) 

I'll take a look at it and see how suitable it is for my use.  If it's 
generic enough and a
suitable framework, I'll see if I can't wrap it in a plugin for 
inclusion in Squirrel.  Thanks
for the link Keith!

Rob

robert wrote:

> Hi,
>
> I have an idea for a plugin that I've been mulling over on and off for 
> the last year.  But
> before I started working on it I wanted to follow the guidelines set 
> forth in the project FAQ:
>
> "If you have got an idea for a plugin just send a message to the 
> SQuirreL Developers
> list giving a brief description. This helps to ensure that two people 
> don't develop the same plugin."
>
> Here's the problem I think I can solve by writing a plugin for SQuirreL:
>
> We have a commercial J2EE app that - in theory - can run on several 
> different app servers
> using several different databases (embedded as well as stand-alone).  
> The thorny problem
> comes when it's time to test a release, we need to be able to run the 
> same tests against the
> same data, in different app servers and different databases.  Because 
> the application has a
> rich client interface (via applet) much testing needs to be performed 
> by hand.  Even some
> of the test setup has to occur using the GUI as we don't yet have a 
> way to automate it. I need
> to be able to setup a test database in Oracle, for instance, setup/run 
> some tests, then at some
> point switch over to MySQL using the same data that was in Oracle,  
> then again re-run some
> tests, then at some point switch over to HyperSonic (SyBase, 
> PointBase, DB2, MS-SQL etc.)
> So my plugin would - I think - build on work done in SQL Scripts 
> plugin by being able to
> use two connections to databases of differing types (Oracle , MySQL), 
> asking the user for
> input schema on Oracle and output database in MySQL.  The challenge in 
> doing this is
> mapping the types - perhaps a configuration dialog would allow the 
> user to choose to use
> default mappings (Oracle:NUMBER -> MySQL:MEDIUM INT) or customize them.
> The plugin could then create tables/views in MySQL using the 
> definitions in Oracle.  Then it would
> read records in each table in Oracle, and write them into the 
> corresponding table in MySQL.
>
> So, is anyone currently working on such a plugin and if so, could I 
> help?  If not, do you all
> think this would be a useful plugin to include with SQuirreL, or 
> perhaps just distribute it on
> my own (it would still be open source licensed)?
>
> Rob Manning




CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83