RE: Restore SQL collection to a different name?

["Tim Kredlo" <TKredlo@xxxxxxxxxxxxxxxx>]

Technical difficulties aside, I would have to agree with David that one
should be able to do this, and do it easily.

Tim Kredlo


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, April 06, 2005 10:37 AM
To: Midrange Systems Technical Discussion
Subject: RE: Restore SQL collection to a different name?


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.
> 
> 

-- 
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.