It should work. There should not be any references to the hardcoded server
names in the workflow.
You could find the sqls to search for workflow server references in this
forum or you could write your own sqls.
Only stuff that did not work for us is AIE. So we had to reinstall AIE
after db copy.
We did very similar thing when we deployed ITSM 7.6.03 mid last year.
ITSM is installed in dev and production independently.
Then in dev server we did all configurations, tested thoroughly. Before
deploying it to production we just deleted all the data created during
testing in Incident,Change,Task main and child forms. Then copied the db
and put that into our production server and then did a few changes. I
At that time I did a search on this forum and there were several postings
with the schema names that need to be touched after the db copy.
I mentioned all those here but many of them are not relevant to recent
versions.
Copy db from Staging to Production during the initial production
deployment:
Pre copy steps:
1. In production servers(2 servers) disable email engine in ar.conf
2. In dev server disable email mail boxes
3. Delete all email entries
Post db copy:
1. Update the default web path
2. Update Servername, Servergroupname, servergroup ranking entries
3. Form data changes:
--> Report form entries with new Server Name -- change server name to
<development>.fqdn or <development>
--> SHARE:Application_Properties, HelpFile URL pointers
--> SYS:Application form -- Survey URL
--> CAI Application Registry -- In Connection tab, change all Server
names from <production>.fqdn to <development>.fqdn
--> SHR:Association -- The server name is stored in two fields on the form
- Server 1 and Server 2
--> Configure Custom Form Info
--> SYS:Attachments form
--> CMS Configuration Management
--> AP:Notifications - Check any custom notifications with Server links
--> AP:Rule Definition (Server = "@")
--> AR System Server Group Operation Ranking
--> AR System User Preferences -- Change Report Server values from
<production> to <development> for any user account you
are going to log in with on development
--> AR System Administrator Preferences -- Partial List Settings - Partial
List Details:Other - Pack List Settings
--> AR System Searches Preference -- Delete records from original server
--> AR System User Central File -- Delete records for user
--> KMS:Administration_Integration-- Change Server Name and Short
Description
--> SRD:STAGE:MasterDataMappingList
--> SRM:ApplicationSettings, if SRM installed, to point to correct web path
--> AST:ARServerConnection -- AR Login Info
--> AST:ComplianceARBased_Advanced--AR System License Type Compliance
--> SYS:Escalations
--> SYS:Attachments
--> SLM:ConfigPreferences -- Update Dashboard MidTier URL
--> SLM:RuleActionSetValue_base -- Found four records to change with
SLA_destination Server Name =
<production>.fqdn,Changed all of them to "@"
--> SLA data sources, service agreements, and service targets with
milestones, after the db had been restored
--> CHG:CCMCalendar:PrintActionWUT -- Active Links that contain server
references
--> AREmail Configuration -- update with production email accounts
--> Table fields -- check with sql select distinct tfserver from field_table
--> AIS:GlobalPreferences form (Atrium Impact Simulator)
--> AIE > EIE:ApplicationSettings form (field name: Help File Path)
--> AIE > EIE:BackUpLoadFlag form entries (field names: Host, Internal
Instance Name,InstanceName)
--> AIE > EIE:DataExchange form entries (field names: Instance Name,
zTmpInstanceAlias)
--> BMC.CORE.CONFIG:BMC_FederatedInterface records (Field name:
ARServerName)
--> IEORA:RuleHelper (field name: Path)
--> EIE:CommonDialog (Help File Path)
--> Reinstall and Reconfigure AIE and all Data Exchanges
4.The mid-tier configuration, where you specify the Data Visualization
server
5.If you have customised any of the OOB notification messages to include a
hardcoded a url then you need to change the server name reference.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
