Re: [Non-DoD Source] Re: need input about data migration after Upgrade

[LJ LongWing]

I would use each in a different situation.

RRRChive: I would use when I have two identical systems that I'm migrating
data between (prod->dev for example)

DDM: Useful for doing the migration from version X to version X+1it
contains all of the mappings to move data between versions when doing
staged upgrades.



On Wed, Apr 19, 2017 at 6:38 AM, Murnane, Phil 
wrote:

> **
>
> We've used DDM and RRR|Chive successfully on various projects.  Misi's
> tool is scriptable and very fast compared to DDM.  DDM can schedule code
> and data migrations.  Generally both require the Last-Modified date/time
> field to be accurate.  Overall, I'd personally recommend RRR|Chive.
>
>
> HTH,
>
> --Phil
> --
> *From:* Action Request System discussion list(ARSList) <
> arslist@ARSLIST.ORG> on behalf of Nicosia, Ryan J. CTR USSOCOM HQ <
> ryan.nicosia@socom.mil>
> *Sent:* Wednesday, April 19, 2017 8:14 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: [Non-DoD Source] Re: need input about data migration after
> Upgrade
>
> I have to disagree.  We used DDM with great success but it does require
> admin freeze on all deletion activities of your production environment.
> That said, there are ways to get around that as well but purging the form
> in question on your target server and telling DDM to just pull everything
> over.
>
> Once you get to the point where you are running DDM every few days, the
> errors are easy to identify and clean up and you can re-run a specific
> package as needed.
>
> Ryan
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [
> mailto:arslist@ARSLIST.ORG ] On Behalf Of Mohamed
> Kamruzzaman
> Sent: Wednesday, April 19, 2017 5:50 AM
> To: arslist@ARSLIST.ORG
> Subject: [Non-DoD Source] Re: need input about data migration after Upgrade
>
> Hi Amit,
>
> Agree with Vinod, you may want to look at alternate solution considering
> you are looking at migrating and cleaning your data. You will want to
> migrate over foundation, configuration and transactional data onto ITSM 9.x
> . This is an ideal time to clean up data, remapping Prod cats and Op Cats
> etc. and potentially archive some of the tickets that you no longer need.
>
> We use our Customer Move Tool (more info [CAUTION]
> http://www.alderstone.com/cmt) for the migration from previous ITSM
> versions to the latest, as we can migrate all modules data or a reduced set
> (including transformation and cleaning of data), depending on your
> requirements. In general we've been able to move entire data set within a
> day ensuring a smooth migration. Please let me know if you would like to
> talk about this in more detail or have any specific questions.
>
> Regards,
> Mohamed
>
> Mohamed Kamruzzaman. Alderstone.com +962776723269 <+962%207%207672%203269>
> | mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn:
> Mohamed-Kamruzzaman
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: [Non-DoD Source] Re: need input about data migration after Upgrade

[Murnane, Phil]

We've used DDM and RRR|Chive successfully on various projects.  Misi's tool is 
scriptable and very fast compared to DDM.  DDM can schedule code and data 
migrations.  Generally both require the Last-Modified date/time field to be 
accurate.  Overall, I'd personally recommend RRR|Chive.

HTH,

--Phil


From: Action Request System discussion list(ARSList)  on 
behalf of Nicosia, Ryan J. CTR USSOCOM HQ 
Sent: Wednesday, April 19, 2017 8:14 AM
To: arslist@ARSLIST.ORG
Subject: Re: [Non-DoD Source] Re: need input about data migration after Upgrade

I have to disagree.  We used DDM with great success but it does require admin 
freeze on all deletion activities of your production environment.  That said, 
there are ways to get around that as well but purging the form in question on 
your target server and telling DDM to just pull everything over.

Once you get to the point where you are running DDM every few days, the errors 
are easy to identify and clean up and you can re-run a specific package as 
needed.

Ryan

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Kamruzzaman
Sent: Wednesday, April 19, 2017 5:50 AM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: need input about data migration after Upgrade

Hi Amit,

Agree with Vinod, you may want to look at alternate solution considering you 
are looking at migrating and cleaning your data. You will want to migrate over 
foundation, configuration and transactional data onto ITSM 9.x . This is an 
ideal time to clean up data, remapping Prod cats and Op Cats etc. and 
potentially archive some of the tickets that you no longer need.

We use our Customer Move Tool (more info [CAUTION] 
http://www.alderstone.com/cmt) for the migration from previous ITSM versions to 
the latest, as we can migrate all modules data or a reduced set (including 
transformation and cleaning of data), depending on your requirements. In 
general we've been able to move entire data set within a day ensuring a smooth 
migration. Please let me know if you would like to talk about this in more 
detail or have any specific questions.

Regards,
Mohamed

Mohamed Kamruzzaman. Alderstone.com +962776723269 | 
mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: 
Mohamed-Kamruzzaman

___
UNSUBSCRIBE or access ARSlist Archives at [CAUTION] 
www.arslist.org "Where the Answers Are, and have been 
for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at 
www.arslist.org
"Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: [Non-DoD Source] Re: need input about data migration after Upgrade

[Nicosia, Ryan J. CTR USSOCOM HQ]

I have to disagree.  We used DDM with great success but it does require admin 
freeze on all deletion activities of your production environment.  That said, 
there are ways to get around that as well but purging the form in question on 
your target server and telling DDM to just pull everything over.

Once you get to the point where you are running DDM every few days, the errors 
are easy to identify and clean up and you can re-run a specific package as 
needed.

Ryan

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Kamruzzaman
Sent: Wednesday, April 19, 2017 5:50 AM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: need input about data migration after Upgrade

Hi Amit,

Agree with Vinod, you may want to look at alternate solution considering you 
are looking at migrating and cleaning your data. You will want to migrate over 
foundation, configuration and transactional data onto ITSM 9.x . This is an 
ideal time to clean up data, remapping Prod cats and Op Cats etc. and 
potentially archive some of the tickets that you no longer need. 
 
We use our Customer Move Tool (more info [CAUTION] 
http://www.alderstone.com/cmt) for the migration from previous ITSM versions to 
the latest, as we can migrate all modules data or a reduced set (including 
transformation and cleaning of data), depending on your requirements. In 
general we've been able to move entire data set within a day ensuring a smooth 
migration. Please let me know if you would like to talk about this in more 
detail or have any specific questions.

Regards,
Mohamed

Mohamed Kamruzzaman. Alderstone.com +962776723269 | 
mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: 
Mohamed-Kamruzzaman

___
UNSUBSCRIBE or access ARSlist Archives at [CAUTION] www.arslist.org "Where the 
Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: need input about data migration after Upgrade

[Misi Mladoniczky]

Hi,

RRR|Chive might help you. It is free to use but low level. You need to know 
exactly what you want to. It uses the modify-date of the records to find which 
ones to add/update/remove, so you need to update that column when working at 
DB-level. Alternatively you can skip updating the modify-date (C6) column and 
RRR|Chive will not touch that record as it would be considered the same in 
source/target. You did not say if the cleaning activity happened in the source 
or target environment...

https://rrr.se/cgi/index?pg=chive (https://rrr.se/cgi/index?pg=chive)

You might also consider talking to Ben Chernys at 
http://www.softwaretoolhouse.com/ (http://www.softwaretoolhouse.com/) as he has 
ready made scripts for his commercial Meta-Update to do ITSM migrations. I have 
not tried it myself though, but Ben should be able to tell you what he can and 
can not do.

Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 
2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
Find these products, and many free tools and utilities, at http://rrr.se 
(http://rrr.se)
April 19, 2017 9:11 AM, "Amit B"  wrote:

**Hello All,
We are in the middle of upgrading our ITSM . I have one question about data 
migration. As we have opted parallel upgrade ,i mean we have build separate 
server and took DB backup from current prod and dump it on new server. So 
currently existing infra is up & running and lot of data cleanup is happening 
based on business requirement but this data cleanup is happening from DB. So my 
question is whether DDM will have ability to identify records got modified via 
DB ? 
Reagrds, 
Amit B  _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: need input about data migration after Upgrade

[Mohamed Kamruzzaman]

Hi Amit,

Agree with Vinod, you may want to look at alternate solution considering you 
are looking at migrating and cleaning your data. You will want to migrate over 
foundation, configuration and transactional data onto ITSM 9.x . This is an 
ideal time to clean up data, remapping Prod cats and Op Cats etc. and 
potentially archive some of the tickets that you no longer need. 
 
We use our Customer Move Tool (more info http://www.alderstone.com/cmt) for the 
migration from previous ITSM versions to the latest, as we can migrate all 
modules data or a reduced set (including transformation and cleaning of data), 
depending on your requirements. In general we've been able to move entire data 
set within a day ensuring a smooth migration. Please let me know if you would 
like to talk about this in more detail or have any specific questions.

Regards,
Mohamed

Mohamed Kamruzzaman. Alderstone.com +962776723269 | 
mohamed.kamruzza...@alderstone.com | Skype: mkamruzzaman | LinkedIn: 
Mohamed-Kamruzzaman

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: need input about data migration after Upgrade

[Vinod Gaidhani]

Hi Amit,

DDM is not capable of handling any data removal activities for e.g. If you 
remove any permission from people form, it will reappear after applying DDM. It 
is worst tool I have used ever honestly, considering the lack of information 
provided in docs. Use it very carefully. 

Sent from my iPhone

> On 19-Apr-2017, at 12:37 PM, Amit B  wrote:
> 
> **
> Hello All,
> 
> We are in the middle  of upgrading our ITSM . I have one question about data 
> migration. As we have opted  parallel upgrade ,i mean we have build separate 
> server and took DB backup from current prod and dump it on new server. So 
> currently existing infra is up & running and lot of data cleanup is happening 
> based on business requirement but this data cleanup is happening from DB. So 
> my question is whether DDM will have ability to identify records got modified 
> via DB ? 
> 
> Reagrds,
> 
> Amit B
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

need input about data migration after Upgrade

[Amit B]

Hello All,

We are in the middle  of upgrading our ITSM . I have one question about
data migration. As we have opted  parallel upgrade ,i mean we have build
separate server and took DB backup from current prod and dump it on new
server. So currently existing infra is up & running and lot of data cleanup
is happening based on business requirement but this data cleanup is
happening from DB. So my question is whether DDM will have ability to
identify records got modified via DB ?

Reagrds,

Amit B

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"