PeopleSoft - SQL Server clone script

Question

I am working for a county government as a consultant for PeopleSoft using SQL Server. When they restore a DEV instance from PROD, they have to manually stop the web server, app server and batch server, then they do the restore. Afterward they have to change all references to PROD in the cloned DEV instance. Everything is done manually and takes a couple of hours.

Can anyone point me to scripts for PeopleSoft restores that automate bringing down/up the web, app and batch servers and all the other tasks so they don't have to be done manually?

---

Life is hard, but it's harder when you're stupid! John 'Duke' Wayne

---

Life is hard, but it's harder when you're stupid! John 'Duke' Wayne

Answer 1

This question should be posted on PeopleSoft support forum as you are asking scripts to bring down app, web and batch servers and proprietary tasks of cleaning up the data within tables.

That being said, a quick search on the internet will provide helpful links like below: http://www.erpassociates.com/peoplesoft-corner-wiki/peoplesoft-administration/cloning-a-peoplesoft-database.html

---

Satish Kartan www.sqlfood.com

Answer 2

Where is this PeopleSoft forum? I can't find it.

---

Life is hard, but it's harder when you're stupid! John 'Duke' Wayne

Answer 3

Where is this PeopleSoft forum? I can't find it.

---

Life is hard, but it's harder when you're stupid! John 'Duke' Wayne

Please visit this URL: PeopleSoft support forum

---

T-SQL Articles
T-SQL e-book by TechNet Wiki Community
T-SQL blog