RE : How to clone a db ?

Hello Marc-Olivier,

the "for recovery" option is part of DBMGUI. As user of create_test_db.sh you have to modify that a bit. Search for the line containing "util_execute init config". Remove all following dbmcli commands in that script (starting with "activate") and you have a create_for_restore script.

Best Regards,
Tilo Heinrich
SAP Labs Berlin

-----Original Message-----
From: Marc-Olivier Meunier [mailto:[email protected]]
Sent: Thursday, August 14, 2003 5:02 PM
To: 'Marcin P'; [email protected]
Subject: RE : How to clone a db ?


How do you specify the "for recovery" option ? I'm using a modified
create_test_db.sh script from depend/misc


> 
> 
> Hi!
> Of course!
> make the backup of your DB,
> create new instance with the desired name
> (be sure to create with "for recovery" option),
> and then recover from your backup.
> It works perfect on my side,
> Bye!!
> Marcin
> Uzytkownik "Marc-Olivier Meunier" <[email protected]> 
> napisal w wiadomosci news:00b801c36270$4e0697e0$0419e48c@froggy...
> > Hi all
> >
> > I would like to know if there is a simple way to clone a db 
> ? I have 
> > my db1 database and i want a db2 database with the same owner, same 
> > dbprocs, same tables, everything the same except the name of the 
> > database. What is the simpliest way to do that ? Is there 
> any script 
> > that can do that easily ?
> >
> > --
> > Marc-Olivier Meunier
> > Ingénieur Projet BKLINK
> > MVH-IRIS
> > 14, rue Rougemont
> > 75009 Paris
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected] 
> http://listserv.sap.com/mailman/listinfo/sapdb> .general
> 
> 

_______________________________________________
sapdb.general mailing list
[email protected]
http://listserv.sap.com/mailman/listinfo/sapdb.general