Hi, The free utility RRR|Chive would be ideal to do something like this.
Come and check out our RRR|Chive tutorial/presentation/demo at WWRUG10! The following config will restore the target to the exact same state as the source server, and only copy/delete those records that need to be handled. The selection is made using the modify-date-field, and the form-list supplied. Download and configurator at: https://www.rrr.se/cgi/rrrchive/main With the guidance of the form-list from Mahesh I have prepared a config-file for RRR|Chive using the online configurator: source_server = prod source_user = Demo source_password = target_server = test target_user = Demo target_password = target_disabledeletefltr = YES target_disablemergefltr = YES qual = SPLITARSCHEMA transfertype = SYNCTOTARGET logfile = rrrchive.log loglevel = NOTICE progressbar = YES multipleforms = COM:Company,\ COM:Company Alias,\ SIT:Site,\ SIT:Site Alias,\ CTM:Region,\ SIT:Site Group,\ SIT:Site Company Association,\ CTM:People Organization,\ CTM:Support Group,\ CTM:Support Group Assignments,\ CTM:Support Group Alias,\ CTM:Support Group On-Call,\ Business Time Workdays,\ Business Time Holidays,\ CTM:People Template,\ CTM:People,\ CTM:People Template PG,\ CTM:People Template SG,\ CTM:People Template SFR,\ CTM:Login ID,\ CTM:People Wallet,\ CTM:People HR Attendance Mgmt,\ CTM:People HR Time Management,\ CTM:People Education,\ CTM:People Travel Profile,\ CTM:People Benefit Info,\ CTM:People IT Skills,\ CTM:People WorkLog,\ NTE:CFG-Notification Events,\ CTM:People Permission Groups,\ CTM:Support Group Association,\ CTM:SupportGroupFunctionalRole,\ CFG:Service Catalog,\ CFG:Service Catalog Assoc,\ PCT:Product Catalog,\ PCT:Product Alias,\ PCT:ProductCompanyAssociation,\ PCT:Product Model-Version,\ PCT:ModelVersion Patch,\ PCT:ProductCatalogAliasMappingForm,\ CFG:Generic Catalog,\ CFG:GenericProdServiceAssoc,\ CFG:GenericCompanyModuleAssoc,\ HPD:Template,\ HPD:TemplateSPGAssoc,\ HPD:Template Associations,\ CFG:Scripts,\ CFG:Group Event Mapping,\ CFG:Decision Tree,\ CFG-DecisionTree-MainBranch,\ CFG:Decision Tree-Branch,\ CFG-DecisionTree-BranchItem You can replace the list of forms with a "*", and then supply a skipforms-list instead. The "*" will only copy data on regular forms: multipleforms = * skipforms = HPD:Help Desk,\ HPD:Associations,\ HPD:WorkLog,\ HPD:Impacted Areas You may also need to skip some other forms... Best Regards - Misi, RRR AB, http://rrr.se > Using the Data Management Tool spreadsheets, you can identify the forms > associated with various types of data. For example: > > *Foundation > Company > COM:Company > COM:Company Alias > > Site > SIT:Site > SIT:Site Alias > CTM:Region > SIT:Site Group > SIT:Site Company Association > > Department > CTM:People Organization > > Support Group > CTM:Support Group > CTM:Support Group Assignments > CTM:Support Group Alias > CTM:Support Group On-Call > Business Time Workdays > Business Time Holidays > > People > CTM:People Template > CTM:People > CTM:People Template PG > CTM:People Template SG > CTM:People Template SFR > CTM:Login ID > CTM:People Wallet > CTM:People HR Attendance Mgmt > CTM:People HR Time Management > CTM:People Education > CTM:People Travel Profile > CTM:People Benefit Info > CTM:People IT Skills > CTM:People WorkLog > NTE:CFG-Notification Events > CTM:People Permission Groups > CTM:Support Group Association > CTM:SupportGroupFunctionalRole > > > > Operational Catalog > CFG:Service Catalog > CFG:Service Catalog Assoc > > Product Catalog > PCT:Product Catalog > PCT:Product Alias > PCT:ProductCompanyAssociation > PCT:Product Model-Version > PCT:ModelVersion Patch > PCT:ProductCatalogAliasMappingForm > > > Generic Catalog > CFG:Generic Catalog > CFG:GenericProdServiceAssoc > CFG:GenericCompanyModuleAssoc > > Process > Incident > HPD:Template > HPD:TemplateSPGAssoc > HPD:Template Associations > CFG:Scripts > CFG:Group Event Mapping > CFG:Decision Tree > CFG-DecisionTree-MainBranch > CFG:Decision Tree-Branch > CFG-DecisionTree-BranchItem > > Transaction > Incident > HPD:Help Desk > HPD:Associations > HPD:WorkLog > HPD:Impacted Areas* > > Thanks > Mahesh > > > > > On Tue, Sep 21, 2010 at 4:20 PM, Raj <[email protected]> wrote: > >> Hello All, >> Need to extract all data from an environment and import into other. >> Which would the best way to approach this ? >> Also, How can I find/distinguish which forms are related to Foundation >> Data, Which are Process Set Up Data Forms and Which are Transactional >> Data Forms ? >> Again, what would be the best way to export data from these and import >> data from these ? >> Admin tool or Data Management Tool , or Third Party tool ? >> Also for data extractions , can I use like a third party tool and do >> data exports for forms starting with A, then move on to B and so on >> until I finish with all the regular forms ? >> Please advise and share your experiences. >> Thanks, Raj >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
