Re: duplicate database

[Flemming Frandsen]

Marty Chiu wrote:

I would like to ask how to duplicate the database
instance to another copy with different name?
e.g copy DEV -> UAT

Do a consistant backup and restore it on the other instance.

This is the script I use to do that, you will want to hack around with it to get paths, database names, users and passwords to match.

You can split it up in a backup and restore script if you want to move the backup to another machine.

--
Regards Flemming Frandsen - http://dion.swamp.dk
PartyTicket.Net co founder & Yet Another Perl Hacker

migrate

Description: application/java-vm