[ajug-members] DB dump / load tool

[Smith, Curt H.]

Hi James,

So far the only tool that wasn't home grown java/swing is MS's DTR facility
that comes with MsSQL server, maybe the enterprise edition.  In general I've
heard good reports that MS's DTR is a good data move / transformation tool.

Re your triggers etc, maybe DTR won't do that.  You're looking for a schema
dump as well as data dump tool.   I've seen the Toad / Quest tools do what
you need but Toad is single DB type and don't support but 3 or so DB's....

I'll post back if I find a better solution.

Curt


-----Original Message-----
From: ajug-members-bounces at ajug.org [mailto:ajug-members-bounces at ajug.org]
On Behalf Of James Mitchell
Sent: Friday, November 12, 2004 10:48 AM
To: General AJUG membership forum (100-200 messages/month)
Subject: Re: [ajug-members] DB dump / load tool

I'm so glad you asked.  I am looking for the same thing.  Something that can

also handle vender specific db items (views, stored procedures, triggers, 
etc) and convert them back and forth based on some configurable conversion 
mechanism/dialect.



--
James Mitchell
Software Engineer / Open Source Evangelist
EdgeTech, Inc.
678.910.8017
AIM: jmitchtx

----- Original Message ----- 
From: "Curt Smith" <chsmith at speakeasy.net>
To: <ajug-members at ajug.org>
Sent: Thursday, November 11, 2004 4:47 PM
Subject: [ajug-members] DB dump / load tool


> Any body know of a gerneric DB tool that can help in dumping tables and
> reloading?  This needs to be a DB agnostic tool because I need to move
> data between pointbase, DB2 etc.
>
> Thanks, curt
>
> Curt Smith
> csmith at javadepot.com
> (w)404-897-3073
> (h)404-294-6686
>
> _______________________________________________
> ajug-members mailing list
> ajug-members at ajug.org
> http://www.ajug.org/mailman/listinfo/ajug-members
> 


_______________________________________________
ajug-members mailing list
ajug-members at ajug.org
http://www.ajug.org/mailman/listinfo/ajug-members