RE: Restore SQL collection to a different name?

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

David,

I see your point, but I disagree with you.

What you're say you're asking for, backup and restore to a new location.  Is in 
my mind different from what you are actually asking for, backup and restore to 
a new schema/collection.

You want it to work like backup and restore of a library, the problem is an SQL 
schema is more complex than a simple library.  Heck, even backup/restore has 
some glitches when you restore to a different library.

I don't think any RDMS would be able to do what are actually asking for.  To 
handle testing/development with any RDBMS, including the iSeries, you need to 
set up separate database servers/instances.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of David Gibbs
> Sent: Wednesday, April 06, 2005 12:55 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Restore SQL collection to a different name?
> 
> 
> rob@xxxxxxxxx wrote:
> > But I'll grant you that a bulk of the shops will use this 
> limitation as 
> > yet another excuse to not adopt journals.  Just as they use 
> any glitch or 
> > temporary limitation in a new technology as a reason to 
> stay with the 
> > techniques they've learned 15 years ago.
> 
> Well, if IBM wants the iSeries to be used as a practical database back
> end for pure java applications, this is the kind of thing that really
> needs to be supported.  The ability to backup a database and 
> restore it
> to a new location (for silly things, like testing) should be 
> part of the
> core OS.
> 
> I'm going to log a DCR today.
> 
> david
> 
> -- 
> David Gibbs
> david@xxxxxxxxxxxx
> 
> Receipt of this message does not grant you permission to send me
> Unsolicited Commercial Email
> 
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>