Re: Restore SQL collection to a different name?

[Mike Wills <koldark@xxxxxxxxx>]

But you are opening up a new can of worms when you deal with SQL. If you are 
looking at duplicating the data, you would have to do a CPYF or something 
along those lines. Lawson created a utility to do something like this. 
Sorry, it is only designed to work with Lawson, and I don't have access to 
the source.

In that case you create a new collection, create the empty tables, then CPYF 
all of the files from the old lib to the new one.

On Apr 4, 2005 11:33 AM, David Gibbs <david@xxxxxxxxxxxx> wrote:
> 
> R Bruce Hoffman wrote:
> >>Does anyone know if there is a way to restore, or copy, a SQL database
> >>collection (created with the sql command 'create collection') to a
> >>different library name and keep it fully operational?
> > It's not just the journals... the catalog tables have a LOT of
> > schema/library qualified descriptions in them for things like views,
> > triggers, RI constraints, etc.
> > and by now you know my answer here... products like ErWin help.
> 
> Unfortunately, something like ErWin just isn't an option. This is on a
> customers system and we don't have the access that a tool like ErWin
> would require (let alone the tool itself).
> 
> Strictly speaking, this kind of thing should be a basic OS400 ability.
> A normal library with database files can be restored to a different
> name, so long as you have all the dependent objects (PF's for all LF's,
> etc). Not being able to restore a database collection library to a
> different name is a major defect IMHO. Backing up a database and
> restoring it to a new location is something that should be able to be
> done without any extra effort.
> 
> 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.
> 
> 


-- 
Mike Wills
Midrange Programmer/Lawson Administrator
koldark@xxxxxxxxx
http://www.mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.