Thanks a lot JD Hood. Regards, Karthik.
From: ARSList [mailto:[email protected]] On Behalf Of JD Hood Sent: Tuesday, July 03, 2018 5:34 PM To: ARSList Subject: Re: Data Migration after upgrade from 2 disparate ITSM instances Hi Karthik, I've used the DDM as a data pump before. It was not designed for that, but it will do the job if given enough time. It's just *extremely* slow. If all you are moving is foundation data, then instead of DDM, you might want to consider exporting the foundation data into the data loader spreadsheets (found in v9 under "Data Management" in the application menu). The tabs of the worksheets will lead you to the forms that hold the data you need to export. Once you get the data in excel, it would be trivial to sort/filter out any duplicates. Then you would just create the data loader jobs and let it do its thing. The hardest part is making sure all the data entered (particularly any data that is a number) are formatted as TEXT values in excel. If it's not TEXT, it could import as an integer or some number format and you will see (for instance) phone numbers like 888.0-555.0-1234.0, instead of 888-555-1234. I find dealing with data errors is much easier with the data loader too, since it imports the data first to a load sheet for data validation. Once in those load sheets, you can use modify all or purpose-built workflow to bulk fix any errors. Good luck with whatever you decide to do! -JDHood On Tue, Jul 3, 2018 at 12:26 AM, Manoharan, Karthik <[email protected]<mailto:[email protected]>> wrote: Hello Listers, Currently there are 2 different ITSM environments A and B running on different version 7.6 and 8.1. I’m planning to setup a single ITSM instance 9.1 by installing a standalone ITSM instance and migrating foundation data from 2 disparate ITSM instances (A+B). I’ve explored BMC Delta Data Migrator and found that we could use it to migrate from instance A. Let's assume I've migrated from instance A. The problem arises when performing migration from the second instance B. There are would be lot of duplicate records(which might not be actually duplicate but from instance A) DDM would identify matching unique index values and may have different Request ID/ Instance ID values from instance A. This would involve lot of manual activity to validate and delete in case of duplicates, but most of the cases we would like to retain records from both servers. Could you please help with any suggestions for any other tool for data migration or any different approach for the same. Thanks in advance. Regards, Karthik. -- ARSList mailing list [email protected]<mailto:[email protected]> https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=vtTp6THS8v_3NkXkX7OYKsYNrKXbAYcsNz87iHKVu88&m=eC-yzIrpuTXCPkO1mo_C-ql-03857q-SdlgTPhYKB0c&s=G6b4whbMUim7XQ0awlhULtzNK82O6VlasuGSdET7Ruc&e=>
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
