Dears: As a legacy site where I learn a lot and contributed little, I would like to inform you of major update on the .NET client where I added a new feature to the data-migration. Which will offer you the possibility of associating a childs, download the ARLiteUser from the following link:
https://communities.bmc.com/docs/DOC-39098 BMC Remedy AR-Liter-User (Action Request Liter User Update/Archive) Data migration of Parent-Child-schema , to help the processing of data-migration, I am introducing additional data-migration feature to the (ArLiteUser/ArLiteArchive) when archiving schema-to-schema you will be able To include associated child-schema that are in inner relationship with the parent-schema. Where the inner relationship between parent and child-schema in such away that the parent primary-key (Request-id --> C1) is pointing to a Field_Id into the child-schema. Note: * I recommend that the foreign key/field-id you points to in the archiving of the child-schema (-K " 536870913") should be indexed. * More child-schema can be added to (ArLiteUser/ArLiteArchive) and this depend on your suggestion * Review the help-document of ArliteUser.exe --> ArliteArchiveHelp As a result the following changes will be occur on the ArLiteArchive command line, hence, the new command line product for ArLiteUser/ArLiteArchive (check documentation for command parameters) From-Schema: A. ArLiteArchive.exe -x From-AR-Server -a From-TcpPort -u From-User -p From-Passwd -s From-Parent-Schema -j From-Child-Schema TO-Schema-Child (Append): -X TO-AR-Server -A To-TcpPort -U To-User -P To-Passwd -S To- Parent-Schema -J To-Child-Schema -K Parent_Child_Inner-Rel_Field_Id (i.e. -k "536870913") Options (Append Optionally) For single Parent-Entry-Id: -l -e "INC00000000001" -E "INC00000000001" Output Resulted Example: *** *** [ArliteArchive/Schema-To-Schema] wait archiving is in process ..... *** ** Wait ... Forward Exporting entries: from [1] to [1] of Schema: [From_Parent_Schema] ********************************************************************** ******* Id:[INC0000000001] is copied from:[From_ Parent_Schema] to :[To_Schema] ********************************************************************** ** [1] Entries Successfully being copied to Schema: [To_ Parent_Schema] *** ArLiteArchive/ChildSchema: ******* Parent-EID[INC0000000001] .. Is in Processing ... ============================================================================================ *** Building Child Schema Id[000000000000007] Selected From-Child-Schema: [Fom_Child_Schema] *** Building Child Schema Id[000000000000015] Selected From-Child-Schema: [Fom_Child_Schema] *** Building Child Schema Id[000000000000101] Selected From-Child-Schema: [Fom_Child_Schema] =========================================================================== ** End of Build Child Schema Parent-EID[INC0000000001]--> No-Child-Id[3] Entries updated the To-Child-Schema: [To_Child_Schema] =========================================================================== **** [ArliteArchive/Schema-To-Schema] Successfully Completely ..... [cid:image001.jpg@01D2E8F1.1C3121B0] Thanks & Regards Ali A. Musa RTTS Operations Support Tel: +966114525539 Mobile: +966550570742 Email: amus...@stc.com.sa<mailto:amus...@stc.com.sa> er [cid:image002.jpg@01D2E8F1.1C3121B0] [cid:image003.jpg@01D2E8F1.1C3121B0] [cid:image004.jpg@01D2E8F1.1C3121B0] [cid:image005.jpg@01D2E8F1.1C3121B0]<http://www.facebook.com/STC> [cid:image006.jpg@01D2E8F1.1C3121B0]<http://twitter.com/#!/STC_KSA> [cid:image007.jpg@01D2E8F1.1C3121B0]<http://www.youtube.com/STCsaudiarabia> stc.com.sa<http://www.stc.com.sa/> [cid:image008.jpg@01D2E8F1.1C3121B0] The information in this email may contain confidential material and it is intended solely for the addresses. Access to this email by anyone else is unauthorized. If you are not the intended recipient, please delete the email and destroy any copies of it, any disclosure, copying, distribution is prohibited and may be considered unlawful. Contents of this email and any attachments may be altered, Statement and opinions expressed in this email are those of the sender, and do not necessarily reflect those of Saudi Telecommunications Company (STC). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"