Its basically oracle exports taken in segments, first the structure only, then data from the T tables excluding data from applications by taking data from tables whose form names begin with prefixes like CFG or SHR or User or Group etc, I have a whole list of them if you need.. Then take data from the H tables from the same above list..
Then take B tables and B%C% tables that belong to the above list.. Then take exports of all meta tables by exporting tables that are owned by ARADMIN and do not begin with a T or H or B.. Fortunately the way these tables are named this condition alone is enough to segregate meta tables from other tables.. I have taken these exports using exp that can be executed from the command line after installing the sql client, and wrote a batch file to generate the necessary parfiles as arguments for the various exports and then later the imports. Then I used imp to import these. The only thing that will be inconsistent after the whole exercise is that the nextid column in the arschema will be inconsistent. This can be fixed by a small script. If you are really interested in performing the above exercise and need help let me know. Joe ----- Original Message ---- From: "Chowdhury, Tauf" <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 9, 2008 5:34:21 AM Subject: Re: Copy Prod Environment to Dev Environment Joe, "if you are on Oracle let me know. I may be able to help you with a slight backdoor method to copy your prod DB to Dev after blowing up your dev DB, by copying just the structure, meta data, and configuration data, and leaving all your main application data on prod.." What is this method? :) -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Joe DeSouza Sent: Wed 10/8/2008 8:05 PM To: [email protected] Subject: Re: Copy Prod Environment to Dev Environment First of all you cannot really downgrade a system by running installers, that won't happen. The only way for you to match your dev to prod is rebuild it. Is there any delta between the prod and dev in terms of customization? You will need to consider that before you attempt to rebuild it or you might loose all those customizations if you do not have them backed up using Remedy def backups.. Since you say you are on SQL, I'm assuming it is MS-SQL... If not and if you are on Oracle let me know. I may be able to help you with a slight backdoor method to copy your prod DB to Dev after blowing up your dev DB, by copying just the structure, meta data, and configuration data, and leaving all your main application data on prod.. Joe ----- Original Message ---- From: Jase Brandon <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, October 8, 2008 7:54:06 PM Subject: Copy Prod Environment to Dev Environment Hello All, I need to copy my production app server environment over to my development environment. Differences in patch levels are: Dev mid-tier = 7.1 Patch 004, Prod mid-tier = 7.1 Patch 002. Dev CMDB = 2.1 Patch 6, Prod CMDB = 2.0.1 Unpatched. I tried unsuccessfully to run the midtier.exe for 7.1 Patch 002 on dev, and I am a tad leary of running the CMDB installer for 2.0.1 since it's already 2.1 Patch 6. I have to have them in synch by Monday and I can't think of what else to do, other then copy my production app server environment over to my development environment. Since our prod environment has three servers, web, SQL, and App servers, and Dev environment is all on one server: I think I need to copy the D:\Program Files\AR System directory from Prod App Server to the Dev AR System Directory, in order to get patch levels synched up to match the prod environment. Can anyone help me out with steps to take to accomplish this? I have been searching .pdf's for hours with no success. Thanks in Advance, Jase _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
