Thanks for replying. I created the script using mysql. But I need an opensource tool that can copy the data from live DB to archive DB (has the same structure

Thanks for replying. I created the script using mysql. But I need an opensource tool that can copy the data from live DB to archive DB (has the same structure of live db) efficiently and the archived data should be accessible through the web application. Basically, I need to update the Archive DB and delete old data from live DB.