Re: Migrator Tool
One point of clarification... I perform the object type by object type migration process when moving a new app or a large number of changes to an environment. For smaller (update) changes (a few dozen of objects) I'll migrate everything at the same time. Jason On Mon, Feb 13, 2017 at 10:27 PM, Jason Miller <jason.mil...@gmail.com> wrote: > To answer your original question, I use Migrator for 99% of the objects I > move between environments. > > Now I don't let it fly full-auto with the default config, that is just > reckless. I use Migrator along with the tracking form/process I detailed > here: https://communities.bmc.com/message/555604#555604. > > First I set all Migrator "Required Objects" to no. I also run migrator in > scripting mode. I then have a flow I usually flow where I run a difference > report of forms, add the forms to the script as appropriate (while > reviewing the differences), and migrate. Then I refresh the difference > report to make sure the results are what I expect. I then do the same thing > with Active Links. Then with Filter and keep repeating this process with > the different object types. > > The 1% that is left is usually renaming objects (I like to fix spelling > issues and rename objects that may have been originally given vague or > misleading names), creating/updating DB views for View Forms that will be > migrated, deleting objects, etc. > > Jason > > On Mon, Feb 13, 2017 at 5:19 AM, Brian Pancia <panc...@finityit.com> > wrote: > >> ** >> >> Misi, >> >> >> I've been playing around with your tools and as always they are pretty >> awesome. There's a new tool in ARS 9.1 called AR System Deployment >> Management that looks pretty promising. Messing around with Migrator was >> painful just like I remembered. It looks like the deployment tool will end >> up replacing Migrator. Another toy to add to the tool box. I'm sure there >> are a few kinks that need to be worked out of the deployment tool, but I'll >> give it a go to see how it works. I'm curious to see anyone else's >> experience with the deployment tool. >> >> >> Thanks again, >> >> >> Brian >> >> >> >> >> -- >> *From:* Brian Pancia >> *Sent:* Friday, February 10, 2017 8:14 AM >> >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Migrator Tool >> >> >> Awesome. New toys to play with. I'll have to play with different >> scenarios depending on the source and destination servers. I'm thinking >> monthly syncs to dev and weekly syncs to test for code. I may do weekly >> data syncs to both environments. In theory Prod and Test should be locked >> down, preventing development directly from there, but that's a different >> beast to tackle. I guess RRRDefDiff will be a good way for me to tell if >> updates are being made to Prod or Test without going through Dev>Test>Prod >> sequence. Batching that process out may be interesting to see if >> developers aren't following the proper process. For a COOP environment I'm >> thinking using SQL replication is probably the best bet. With replication >> I can do near real time updates. >> >> Brian >> -- >> *From:* Action Request System discussion list(ARSList) < >> arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> >> *Sent:* Thursday, February 9, 2017 1:37 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Migrator Tool >> >> ** >> Hi, >> >> Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef >> and RRR|DeleteObject. >> >> The important one is RRR|DefDiff, mening that you can use other tools to >> export/import definitions and delete surplus objects. >> >> https://rrr.se/cgi/tools/main?tool=rrrDefDiff >> >> RRR|DefDiff <https://rrr.se/cgi/tools/main?tool=rrrDefDiff> >> rrr.se >> RRR|DefDiff updated 2015-06-16 Finds differences between two def-files >> >> >> >> https://rrr.se/cgi/tools/main?tool=rrrExportDef >> >> RRR|ExportDef <https://rrr.se/cgi/tools/main?tool=rrrExportDef> >> rrr.se >> RRR|ExportDef updated 2012-11-23 Exports definition files from your server >> >> >> >> https://rrr.se/cgi/tools/main?tool=rrrImportDef >> >> RRR|ImportDef <https://rrr.se/cgi/tools/main?tool=rrrImportDef> >> rrr.se >> usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ >> -silent ] server tcpport user password import.def usage: rrrimportdef -help >> >&g
Re: Migrator Tool
To answer your original question, I use Migrator for 99% of the objects I move between environments. Now I don't let it fly full-auto with the default config, that is just reckless. I use Migrator along with the tracking form/process I detailed here: https://communities.bmc.com/message/555604#555604. First I set all Migrator "Required Objects" to no. I also run migrator in scripting mode. I then have a flow I usually flow where I run a difference report of forms, add the forms to the script as appropriate (while reviewing the differences), and migrate. Then I refresh the difference report to make sure the results are what I expect. I then do the same thing with Active Links. Then with Filter and keep repeating this process with the different object types. The 1% that is left is usually renaming objects (I like to fix spelling issues and rename objects that may have been originally given vague or misleading names), creating/updating DB views for View Forms that will be migrated, deleting objects, etc. Jason On Mon, Feb 13, 2017 at 5:19 AM, Brian Pancia <panc...@finityit.com> wrote: > ** > > Misi, > > > I've been playing around with your tools and as always they are pretty > awesome. There's a new tool in ARS 9.1 called AR System Deployment > Management that looks pretty promising. Messing around with Migrator was > painful just like I remembered. It looks like the deployment tool will end > up replacing Migrator. Another toy to add to the tool box. I'm sure there > are a few kinks that need to be worked out of the deployment tool, but I'll > give it a go to see how it works. I'm curious to see anyone else's > experience with the deployment tool. > > > Thanks again, > > > Brian > > > > > -- > *From:* Brian Pancia > *Sent:* Friday, February 10, 2017 8:14 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Migrator Tool > > > Awesome. New toys to play with. I'll have to play with different > scenarios depending on the source and destination servers. I'm thinking > monthly syncs to dev and weekly syncs to test for code. I may do weekly > data syncs to both environments. In theory Prod and Test should be locked > down, preventing development directly from there, but that's a different > beast to tackle. I guess RRRDefDiff will be a good way for me to tell if > updates are being made to Prod or Test without going through Dev>Test>Prod > sequence. Batching that process out may be interesting to see if > developers aren't following the proper process. For a COOP environment I'm > thinking using SQL replication is probably the best bet. With replication > I can do near real time updates. > > Brian > -- > *From:* Action Request System discussion list(ARSList) < > arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> > *Sent:* Thursday, February 9, 2017 1:37 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Migrator Tool > > ** > Hi, > > Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and > RRR|DeleteObject. > > The important one is RRR|DefDiff, mening that you can use other tools to > export/import definitions and delete surplus objects. > > https://rrr.se/cgi/tools/main?tool=rrrDefDiff > > RRR|DefDiff <https://rrr.se/cgi/tools/main?tool=rrrDefDiff> > rrr.se > RRR|DefDiff updated 2015-06-16 Finds differences between two def-files > > > > https://rrr.se/cgi/tools/main?tool=rrrExportDef > > RRR|ExportDef <https://rrr.se/cgi/tools/main?tool=rrrExportDef> > rrr.se > RRR|ExportDef updated 2012-11-23 Exports definition files from your server > > > > https://rrr.se/cgi/tools/main?tool=rrrImportDef > > RRR|ImportDef <https://rrr.se/cgi/tools/main?tool=rrrImportDef> > rrr.se > usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ > -silent ] server tcpport user password import.def usage: rrrimportdef -help > > > > https://rrr.se/cgi/tools/main?tool=rrrDeleteObject > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > RRR|Home <http://www.rrr.se/> > www.rrr.se > RRR|Log Fix specific performance problems or work proactively with > performance by using RRR|Log. It will help you make sense of the > information in the Remedy log ... > > > > > 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 > > RRR|Home <http://rrr.se/> > rrr.se > RRR|Log Fix specific performance problems
Re: Migrator Tool
Misi, I've been playing around with your tools and as always they are pretty awesome. There's a new tool in ARS 9.1 called AR System Deployment Management that looks pretty promising. Messing around with Migrator was painful just like I remembered. It looks like the deployment tool will end up replacing Migrator. Another toy to add to the tool box. I'm sure there are a few kinks that need to be worked out of the deployment tool, but I'll give it a go to see how it works. I'm curious to see anyone else's experience with the deployment tool. Thanks again, Brian From: Brian Pancia Sent: Friday, February 10, 2017 8:14 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool Awesome. New toys to play with. I'll have to play with different scenarios depending on the source and destination servers. I'm thinking monthly syncs to dev and weekly syncs to test for code. I may do weekly data syncs to both environments. In theory Prod and Test should be locked down, preventing development directly from there, but that's a different beast to tackle. I guess RRRDefDiff will be a good way for me to tell if updates are being made to Prod or Test without going through Dev>Test>Prod sequence. Batching that process out may be interesting to see if developers aren't following the proper process. For a COOP environment I'm thinking using SQL replication is probably the best bet. With replication I can do near real time updates. Brian From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> Sent: Thursday, February 9, 2017 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool ** Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff RRR|DefDiff<https://rrr.se/cgi/tools/main?tool=rrrDefDiff> rrr.se RRR|DefDiff updated 2015-06-16 Finds differences between two def-files https://rrr.se/cgi/tools/main?tool=rrrExportDef RRR|ExportDef<https://rrr.se/cgi/tools/main?tool=rrrExportDef> rrr.se RRR|ExportDef updated 2012-11-23 Exports definition files from your server https://rrr.se/cgi/tools/main?tool=rrrImportDef RRR|ImportDef<https://rrr.se/cgi/tools/main?tool=rrrImportDef> rrr.se usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ -silent ] server tcpport user password import.def usage: rrrimportdef -help https://rrr.se/cgi/tools/main?tool=rrrDeleteObject Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) RRR|Home<http://www.rrr.se/> www.rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... 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 RRR|Home<http://rrr.se/> rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... February 9, 2017 5:52 PM, "Brian Pancia" <panc...@finityit.com<mailto:%22Brian%20Pancia%22%20<panc...@finityit.com>>> wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop. Brian DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. _AR
Re: Migrator Tool
Awesome. New toys to play with. I'll have to play with different scenarios depending on the source and destination servers. I'm thinking monthly syncs to dev and weekly syncs to test for code. I may do weekly data syncs to both environments. In theory Prod and Test should be locked down, preventing development directly from there, but that's a different beast to tackle. I guess RRRDefDiff will be a good way for me to tell if updates are being made to Prod or Test without going through Dev>Test>Prod sequence. Batching that process out may be interesting to see if developers aren't following the proper process. For a COOP environment I'm thinking using SQL replication is probably the best bet. With replication I can do near real time updates. Brian From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> Sent: Thursday, February 9, 2017 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool ** Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff RRR|DefDiff<https://rrr.se/cgi/tools/main?tool=rrrDefDiff> rrr.se RRR|DefDiff updated 2015-06-16 Finds differences between two def-files https://rrr.se/cgi/tools/main?tool=rrrExportDef RRR|ExportDef<https://rrr.se/cgi/tools/main?tool=rrrExportDef> rrr.se RRR|ExportDef updated 2012-11-23 Exports definition files from your server https://rrr.se/cgi/tools/main?tool=rrrImportDef RRR|ImportDef<https://rrr.se/cgi/tools/main?tool=rrrImportDef> rrr.se usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ -silent ] server tcpport user password import.def usage: rrrimportdef -help https://rrr.se/cgi/tools/main?tool=rrrDeleteObject Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) RRR|Home<http://www.rrr.se/> www.rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... 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 RRR|Home<http://rrr.se/> rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... February 9, 2017 5:52 PM, "Brian Pancia" <panc...@finityit.com<mailto:%22Brian%20Pancia%22%20<panc...@finityit.com>>> wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop. Brian DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. ___
Re: Migrator Tool
Hi, Yes, your outline is pretty much correct. 1. Export complete DEF (or a prefix or something like that) using RRR|ExportDef (or do it with other tools) 2. Run RRR|DefDiff will produce one def file with new objects and one def file with updated objects, and one def files with objects to delete. 3. RRR|ImportDef can be used to import the updated and new object def files (or you can do this with other tools) 4. RRR|DeleteObjects can delete objects included in the delete-def-file from the target server (or you can delete the objects manually with other tools) After all steps are completed, I typically export a new def file and then use RRR|DefDiff again to verify that the target server looks as desired, meaning no diffs this time. 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) February 9, 2017 8:01 PM, "Brian Pancia" wrote: I'll have to play around with that combo too. Your tools are always top notch. Would this be the correct steps: - run RRRExportDef on both Source and Destination server - run RRRDefDiff on the files created - run RRRImportDef or RRRDeleteObject based on the results of RRRDefDiff So it looks like for RRRImportDef I would need to rerun RRRExportDef based on RRRDefDiff results. For RRRDeleteObject I would feed the parameters of the objects I would like to delete from RRRDefDiff. If that's the correct steps, can it be automated in a batch file or does it require manual intervention? Brian From: Action Request System discussion list(ARSList) on behalf of Misi Mladoniczky Sent: Thursday, February 9, 2017 1:37 PM To: arslist@ARSLIST.ORG (mailto:arslist@ARSLIST.ORG) Subject: Re: Migrator Tool ** Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff (https://rrr.se/cgi/tools/main?tool=rrrDefDiff) RRR|DefDiff (https://rrr.se/cgi/tools/main?tool=rrrDefDiff) rrr.se RRR|DefDiff updated 2015-06-16 Finds differences between two def-files https://rrr.se/cgi/tools/main?tool=rrrExportDef (https://rrr.se/cgi/tools/main?tool=rrrExportDef) RRR|ExportDef (https://rrr.se/cgi/tools/main?tool=rrrExportDef) rrr.se RRR|ExportDef updated 2012-11-23 Exports definition files from your server https://rrr.se/cgi/tools/main?tool=rrrImportDef (https://rrr.se/cgi/tools/main?tool=rrrImportDef) RRR|ImportDef (https://rrr.se/cgi/tools/main?tool=rrrImportDef) rrr.se usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ -silent ] server tcpport user password import.def usage: rrrimportdef -help https://rrr.se/cgi/tools/main?tool=rrrDeleteObject (https://rrr.se/cgi/tools/main?tool=rrrDeleteObject) Best Regards - Misi, RRR AB, http://www.rrr.se (http://www.rrr.se) (ARSList MVP 2011) RRR|Home (http://www.rrr.se/) www.rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... 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) RRR|Home (http://rrr.se/) rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... February 9, 2017 5:52 PM, "Brian Pancia" wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop.
Re: Migrator Tool
Brian, I have used Misi's tools in batch files and, yes, they can be automated, i.e called from an escalation. One of my favorite tricks is opening several DOS windows and running concurrent instances of rrrChive to sync data across servers. In that case, each instance synchronized data from forms with different prefixes (CHG, SYS, INC, etc.) I recommend the 'rrr' tools as they have helped me MANY times, for many clients. I haven't used Migrator in a long time (thanks, again Misi), but the last time I did it was less reliable and slower than the free tools. HTH, Joel Joel Sender * jdsen...@earthlink.net From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Thursday, February 9, 2017 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool ** I'll have to play around with that combo too. Your tools are always top notch. Would this be the correct steps: - run RRRExportDef on both Source and Destination server - run RRRDefDiff on the files created - run RRRImportDef or RRRDeleteObject based on the results of RRRDefDiff So it looks like for RRRImportDef I would need to rerun RRRExportDef based on RRRDefDiff results. For RRRDeleteObject I would feed the parameters of the objects I would like to delete from RRRDefDiff. If that's the correct steps, can it be automated in a batch file or does it require manual intervention? Brian _ From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> Sent: Thursday, February 9, 2017 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool ** Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff <https://rrr.se/cgi/tools/main?tool=rrrDefDiff> RRR|DefDiff rrr.se RRR|DefDiff updated 2015-06-16 Finds differences between two def-files https://rrr.se/cgi/tools/main?tool=rrrExportDef <https://rrr.se/cgi/tools/main?tool=rrrExportDef> RRR|ExportDef rrr.se RRR|ExportDef updated 2012-11-23 Exports definition files from your server https://rrr.se/cgi/tools/main?tool=rrrImportDef <https://rrr.se/cgi/tools/main?tool=rrrImportDef> RRR|ImportDef rrr.se usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ -silent ] server tcpport user password import.def usage: rrrimportdef -help https://rrr.se/cgi/tools/main?tool=rrrDeleteObject Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) <http://www.rrr.se/> RRR|Home www.rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... 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/> RRR|Home rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... February 9, 2017 5:52 PM, "Brian Pancia" <panc...@finityit.com <mailto:%22brian%20pancia%22%20%3cpanc...@finityit.com%3e> > wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop. Brian DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Migrator Tool
I'll have to play around with that combo too. Your tools are always top notch. Would this be the correct steps: - run RRRExportDef on both Source and Destination server - run RRRDefDiff on the files created - run RRRImportDef or RRRDeleteObject based on the results of RRRDefDiff So it looks like for RRRImportDef I would need to rerun RRRExportDef based on RRRDefDiff results. For RRRDeleteObject I would feed the parameters of the objects I would like to delete from RRRDefDiff. If that's the correct steps, can it be automated in a batch file or does it require manual intervention? Brian From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on behalf of Misi Mladoniczky <m...@rrr.se> Sent: Thursday, February 9, 2017 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator Tool ** Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff RRR|DefDiff<https://rrr.se/cgi/tools/main?tool=rrrDefDiff> rrr.se RRR|DefDiff updated 2015-06-16 Finds differences between two def-files https://rrr.se/cgi/tools/main?tool=rrrExportDef RRR|ExportDef<https://rrr.se/cgi/tools/main?tool=rrrExportDef> rrr.se RRR|ExportDef updated 2012-11-23 Exports definition files from your server https://rrr.se/cgi/tools/main?tool=rrrImportDef RRR|ImportDef<https://rrr.se/cgi/tools/main?tool=rrrImportDef> rrr.se usage: rrrimportdef [ -l error.log ] [ -e error.def ] [ -verbose ] [ -silent ] server tcpport user password import.def usage: rrrimportdef -help https://rrr.se/cgi/tools/main?tool=rrrDeleteObject Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) RRR|Home<http://www.rrr.se/> www.rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... 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 RRR|Home<http://rrr.se/> rrr.se RRR|Log Fix specific performance problems or work proactively with performance by using RRR|Log. It will help you make sense of the information in the Remedy log ... February 9, 2017 5:52 PM, "Brian Pancia" <panc...@finityit.com<mailto:%22Brian%20Pancia%22%20<panc...@finityit.com>>> wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop. Brian DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Migrator Tool
Hi, Why not try a combination of RRR|ExportDef, RRR|DefDiff, RRR|ImportDef and RRR|DeleteObject. The important one is RRR|DefDiff, mening that you can use other tools to export/import definitions and delete surplus objects. https://rrr.se/cgi/tools/main?tool=rrrDefDiff (https://rrr.se/cgi/tools/main?tool=rrrDefDiff) https://rrr.se/cgi/tools/main?tool=rrrExportDef (https://rrr.se/cgi/tools/main?tool=rrrExportDef) https://rrr.se/cgi/tools/main?tool=rrrImportDef (https://rrr.se/cgi/tools/main?tool=rrrImportDef) https://rrr.se/cgi/tools/main?tool=rrrDeleteObject (https://rrr.se/cgi/tools/main?tool=rrrDeleteObject) 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) February 9, 2017 5:52 PM, "Brian Pancia" wrote: I'm blowing off the dust on BMC Migrator. It has been years since I've messed with it. I've used it in the past to migrate small amounts of code from dev to test to production. What I'm looking at now is using it as a sync tool between the environments for code only. I've usually just done a database backup and restore in the past and for small code migrations I just export/import .def files. There are definitely pros/cons to all these methods. My plan now is to use RRRChive to migrate data updates and BMC Migrator to do code migration. This will give me much more control then a simple database backup and restore. Is anyone currently taking this approach between dev/test/prod. We're using MS SQL 2012 on the backend, which I'll use database replication between prod and coop. Brian DISCLAIMER: The information contained in this e-mail and its attachments contain confidential information belonging to the sender, which is legally privileged. The information is intended only for the use of the recipient(s) named above. If you are not the intended recipient, you are notified that any disclosure, copying, distribution or action in reliance upon the contents of the information transmitted is strictly prohibited. If you have received this information in error, please delete it immediately. _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: Migrator tool: No servers for this account
In migrator go to Tools-Licenses to add the license for the server. Another thing to try: I don't know if 7.1 has a multilicense file but try removing /etc/arsystem/.multilicense and restarting the server. That may resolve it. A third issue is that if you are in a server group environment you need to check that it is setup properly. If configured wrong the Disable Admin Operations on both servers will be set to True which will cause migrator to not work right. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, July 09, 2010 2:58 PM To: arslist@ARSLIST.ORG Subject: Migrator tool: No servers for this account ** Dear List, Trying to get the Migrator tool working. It is licensed on both our AR servers. I open the tool and click the New Server Window icon. It lets me log in to both servers, but the choice window only lists one of the two servers. If I try again and only log in to the missing server, I get No servers for this account. Why would the Migrator be able to see only one of the servers? The User and Admin tools can see both servers. (ARS 7.1 p3, Migrator tool 7.5 ) Dwayne Martin James Madison University _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
Re: Migrator tool: No servers for this account SOLVED
Thank, Sean, Re: In migrator go to Tools-Licenses to add the license for the server. I thot I had already taken care of that but I hadn't. Sorry, it's Friday and my brain is fried. Dwayne From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Garrison, Sean (Norcross) Sent: Friday, July 09, 2010 3:10 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool: No servers for this account ** In migrator go to Tools-Licenses to add the license for the server. Another thing to try: I don't know if 7.1 has a multilicense file but try removing /etc/arsystem/.multilicense and restarting the server. That may resolve it. A third issue is that if you are in a server group environment you need to check that it is setup properly. If configured wrong the Disable Admin Operations on both servers will be set to True which will cause migrator to not work right. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martin, Dwayne Sent: Friday, July 09, 2010 2:58 PM To: arslist@ARSLIST.ORG Subject: Migrator tool: No servers for this account ** Dear List, Trying to get the Migrator tool working. It is licensed on both our AR servers. I open the tool and click the New Server Window icon. It lets me log in to both servers, but the choice window only lists one of the two servers. If I try again and only log in to the missing server, I get No servers for this account. Why would the Migrator be able to see only one of the servers? The User and Admin tools can see both servers. (ARS 7.1 p3, Migrator tool 7.5 ) Dwayne Martin James Madison University _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: Migrator tool not replacing record SOLVED - again
My mistake. I got an off-line email from Marc Bowen (below). He reminded me that there is a Merge Option setting in the Data Migrations Settings. I had set it in the general config window, but not in this. Thanks again to Marc and all others who replied, Dwayne Date: Fri 15 Jun 16:12:55 EDT 2007 From: Bowen, Marc [EMAIL PROTECTED] Add To Address Book | This is Spam Subject: RE: Migrator tool not replacing record SOLVED To: [EMAIL PROTECTED] I performed data migration the same way you described and I received the desired results. Another way that I usually perform migrations (if I don't want everything) is to right click on the form and choose Form Data Only, select the server then when the data migration setting come up choose data mode (bottom left under data settings) then choose search selection, enter my search criteria then choose Replace Old Entry with New Entry. I also choose Ignore required fields and pattern matching. If this doesn't work the same for you could the problem be that you are using it on a 6.3 server? (even though it shouldn't be a problem) Migrator 7.01 Server 7.01 patch 1 Oracle 10.2 Unix Sun OS 5.10 Marc Bowen Remedy Skilled Professional Office (201) 307-8274 [EMAIL PROTECTED] Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---BeginMessage--- My joy has turned to sorrow. Yesterday I got the Migrator tool to Replace Old Record with New Record. Today I am trying again with a different form. I have the same record in both servers. I made some changes in the destination server record. Then I use the right click method that Frederick described (see below) and select the record and run the migration. But the changes still remain in the destination record. My configuraton still says Replace Old Record with New Record. My Search string pulls up the correct record in a User tool query. Any idea what the problem might be? Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---BeginMessage--- Thanks to all who replied, including those who said that Migrator is a piece of junk. For a while I was afraid that we had made a big mistake in buying it. I agree with Ben that if they are going to charge money for it they should make sure it works in all modes, not just in a special esoteric method. Thanks especially to Frederick for the special esoteric method! I tried the method described below, and IT WORKED! The record data in the destination server got set back to the way it was. I had to go into Tools Options and change Data Migration Mode to Migrate Query Selection. Then when the Data Migration Settings window opened it said Invalid Qualification string before I had even entered it. That scared me for a bit. Is the Frederick method even in the manual? I don't see it, but I am very good at looking right at things and not seeing them. Thanks again, Dwayne Original message Date: Thu, 14 Jun 2007 12:36:19 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Migrator tool not replacing record To: arslist@ARSLIST.ORG ** I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration
Re: Migrator tool not replacing record SOLVED - OOOPS!
My joy has turned to sorrow. Yesterday I got the Migrator tool to Replace Old Record with New Record. Today I am trying again with a different form. I have the same record in both servers. I made some changes in the destination server record. Then I use the right click method that Frederick described (see below) and select the record and run the migration. But the changes still remain in the destination record. My configuraton still says Replace Old Record with New Record. My Search string pulls up the correct record in a User tool query. Any idea what the problem might be? Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---BeginMessage--- Thanks to all who replied, including those who said that Migrator is a piece of junk. For a while I was afraid that we had made a big mistake in buying it. I agree with Ben that if they are going to charge money for it they should make sure it works in all modes, not just in a special esoteric method. Thanks especially to Frederick for the special esoteric method! I tried the method described below, and IT WORKED! The record data in the destination server got set back to the way it was. I had to go into Tools Options and change Data Migration Mode to Migrate Query Selection. Then when the Data Migration Settings window opened it said Invalid Qualification string before I had even entered it. That scared me for a bit. Is the Frederick method even in the manual? I don't see it, but I am very good at looking right at things and not seeing them. Thanks again, Dwayne Original message Date: Thu, 14 Jun 2007 12:36:19 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Migrator tool not replacing record To: arslist@ARSLIST.ORG ** I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ---End Message---
Re: Migrator tool not replacing record
I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record
Patrick, I have to second you on that. We have had so many problems with Migrator screwing things up that I have gone back to the old way of exporting and importing def files. There have been so many incidents of objects successfully migrating when nothing has changed except the Last Modified date. Even the Diff reports come up with things that are identified as different when they are identical in every respect according to the details displayed in the Diff report itself. Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record
I have never gotten the migrator to work 100% correctly for me in any of the versions I've tried. Conceptually its a great tool, doesn't deliver on its promise though. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Wacholz, Jeanette (Jenni) [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/14/2007 12:00 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Migrator tool not replacing record ** Patrick, I have to second you on that. We have had so many problems with Migrator screwing things up that I have gone back to the old way of exporting and importing def files. There have been so many incidents of objects successfully migrating when nothing has changed except the Last Modified date. Even the Diff reports come up with things that are identified as different when they are identical in every respect according to the details displayed in the Diff report itself. Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record
I've always found it was kind of like driving a car that stalls alot ... you have to get that two-footed technique perfected. I've also been using it since Ostream days and I actually love migrator, although I haven't used v7 yet. I used it all the time for migration but followed a certain progression. I did different objects separately. First menus, then forms, then active links, then filters, then escalations etc. Sometimes I'd combine filters and escalations without issues. Sometimes a form or workflow would error out due to busy server or something like that. Being patience, I'd wait a bit ... talk to it softly ... then do the migration and whaalaa ... it would work. Susan On 6/14/07, Ben Cantatore [EMAIL PROTECTED] wrote: ** I have never gotten the migrator to work 100% correctly for me in any of the versions I've tried. Conceptually its a great tool, doesn't deliver on its promise though. Ben Cantatore Remedy Administrator Avon (914) 935-2946 *Wacholz, Jeanette (Jenni) [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/14/2007 12:00 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Migrator tool not replacing record ** Patrick, I have to second you on that. We have had so many problems with Migrator screwing things up that I have gone back to the old way of exporting and importing def files. There have been so many incidents of objects successfully migrating when nothing has changed except the Last Modified date. Even the Diff reports come up with things that are identified as different when they are identical in every respect according to the details displayed in the Diff report itself. *Jenni Wacholz* Remedy Administration Coventry Health Care Inc 480-445-2517 -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *patrick zandi* Sent:* Thursday, June 14, 2007 8:47 AM* To:* [EMAIL PROTECTED] Subject:* Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, *Dwayne Martin* [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at *www.arslist.org*http://www.arslist.org/ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record
I have to agree with Susan. This tool has been a major time saver for me. There have been a few times when I have had to migrate the same object twice but never more then that. Version 7 is the best so far. I cannot imagine going back to the old way. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Thursday, June 14, 2007 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I've always found it was kind of like driving a car that stalls alot ... you have to get that two-footed technique perfected. I've also been using it since Ostream days and I actually love migrator, although I haven't used v7 yet. I used it all the time for migration but followed a certain progression. I did different objects separately. First menus, then forms, then active links, then filters, then escalations etc. Sometimes I'd combine filters and escalations without issues. Sometimes a form or workflow would error out due to busy server or something like that. Being patience, I'd wait a bit ... talk to it softly ... then do the migration and whaalaa ... it would work. Susan On 6/14/07, Ben Cantatore [EMAIL PROTECTED] wrote: ** I have never gotten the migrator to work 100% correctly for me in any of the versions I've tried. Conceptually its a great tool, doesn't deliver on its promise though. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Wacholz, Jeanette (Jenni) [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG 06/14/2007 12:00 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Migrator tool not replacing record ** Patrick, I have to second you on that. We have had so many problems with Migrator screwing things up that I have gone back to the old way of exporting and importing def files. There have been so many incidents of objects successfully migrating when nothing has changed except the Last Modified date. Even the Diff reports come up with things that are identified as different when they are identical in every respect according to the details displayed in the Diff report itself. Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 8:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ ARSlist:Where the Answers Are -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Migrator tool not replacing record
I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record
I use it as well, (its better than nothing), but its problematic, at least for me it has been. If this was shareware, I'd sing praises for it, but for the amount of money spent , I'd expect it to be fully functional. Shrug, maybe my expectations are too high. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Susan Palmer [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/14/2007 01:23 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Migrator tool not replacing record ** I've always found it was kind of like driving a car that stalls alot ... you have to get that two-footed technique perfected. I've also been using it since Ostream days and I actually love migrator, although I haven't used v7 yet. I used it all the time for migration but followed a certain progression. I did different objects separately. First menus, then forms, then active links, then filters, then escalations etc. Sometimes I'd combine filters and escalations without issues. Sometimes a form or workflow would error out due to busy server or something like that. Being patience, I'd wait a bit ... talk to it softly ... then do the migration and whaalaa ... it would work. Susan On 6/14/07, Ben Cantatore [EMAIL PROTECTED] wrote: ** I have never gotten the migrator to work 100% correctly for me in any of the versions I've tried. Conceptually its a great tool, doesn't deliver on its promise though. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Wacholz, Jeanette (Jenni) [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 06/14/2007 12:00 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Migrator tool not replacing record ** Patrick, I have to second you on that. We have had so many problems with Migrator screwing things up that I have gone back to the old way of exporting and importing def files. There have been so many incidents of objects successfully migrating when nothing has changed except the Last Modified date. Even the Diff reports come up with things that are identified as different when they are identical in every respect according to the details displayed in the Diff report itself. Jenni Wacholz Remedy Administration Coventry Health Care Inc 480-445-2517 From: Action Request System discussion list(ARSList) [mailto: ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record SOLVED
Thanks to all who replied, including those who said that Migrator is a piece of junk. For a while I was afraid that we had made a big mistake in buying it. I agree with Ben that if they are going to charge money for it they should make sure it works in all modes, not just in a special esoteric method. Thanks especially to Frederick for the special esoteric method! I tried the method described below, and IT WORKED! The record data in the destination server got set back to the way it was. I had to go into Tools Options and change Data Migration Mode to Migrate Query Selection. Then when the Data Migration Settings window opened it said Invalid Qualification string before I had even entered it. That scared me for a bit. Is the Frederick method even in the manual? I don't see it, but I am very good at looking right at things and not seeing them. Thanks again, Dwayne Original message Date: Thu, 14 Jun 2007 12:36:19 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Migrator tool not replacing record To: arslist@ARSLIST.ORG ** I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record SOLVED
I'm not sure if it is in the manual. I do most of my work in Migrator using the Right-Click menus (maybe that's why I haven't had all the problems other people have seen). Grin Gee... I must be doing good today to be able to get a Method named after me /Grin Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, June 14, 2007 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record SOLVED Thanks to all who replied, including those who said that Migrator is a piece of junk. For a while I was afraid that we had made a big mistake in buying it. I agree with Ben that if they are going to charge money for it they should make sure it works in all modes, not just in a special esoteric method. Thanks especially to Frederick for the special esoteric method! I tried the method described below, and IT WORKED! The record data in the destination server got set back to the way it was. I had to go into Tools Options and change Data Migration Mode to Migrate Query Selection. Then when the Data Migration Settings window opened it said Invalid Qualification string before I had even entered it. That scared me for a bit. Is the Frederick method even in the manual? I don't see it, but I am very good at looking right at things and not seeing them. Thanks again, Dwayne Original message Date: Thu, 14 Jun 2007 12:36:19 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Migrator tool not replacing record To: arslist@ARSLIST.ORG ** I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University -- Patrick Zandi Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Migrator tool not replacing record SOLVED
This is interesting. I have only used the right click method. Must be why I have had very few problems. Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, June 14, 2007 3:31 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record SOLVED I'm not sure if it is in the manual. I do most of my work in Migrator using the Right-Click menus (maybe that's why I haven't had all the problems other people have seen). Grin Gee... I must be doing good today to be able to get a Method named after me /Grin Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, June 14, 2007 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record SOLVED Thanks to all who replied, including those who said that Migrator is a piece of junk. For a while I was afraid that we had made a big mistake in buying it. I agree with Ben that if they are going to charge money for it they should make sure it works in all modes, not just in a special esoteric method. Thanks especially to Frederick for the special esoteric method! I tried the method described below, and IT WORKED! The record data in the destination server got set back to the way it was. I had to go into Tools Options and change Data Migration Mode to Migrate Query Selection. Then when the Data Migration Settings window opened it said Invalid Qualification string before I had even entered it. That scared me for a bit. Is the Frederick method even in the manual? I don't see it, but I am very good at looking right at things and not seeing them. Thanks again, Dwayne Original message Date: Thu, 14 Jun 2007 12:36:19 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Migrator tool not replacing record To: arslist@ARSLIST.ORG ** I have found that opening the form then choosing Data does not work. Try Right-Clicking the form and choosing Form Data Only. After choosing your destination a window opens, click on your migration and the bottom fields become available. Choose Search for the Data Mode Put in your search criteria and set your merge option. I have used Migrator since v3 and while it has it's quirks, I've never had any major problems with it. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 14, 2007 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: Migrator tool not replacing record ** I don't mean to be negative here.. I have had every migrator since and to include ostream.. They still do not have it right.. and I am STILL Stupid enough to give them money for the last umpteen years. I expect to see this product disappear. it is almost useless. On 6/14/07, Dwayne Martin [EMAIL PROTECTED] wrote: Hello Everyone, I am using the Migrator tool to sync data in two systems. In options Data Data merging options I checked Replace Old Record. I select a record that is the same in both systems, and change the data in the destination system. In the Source server I open the form, select Data and find the record. Then I drag the entry into the destination window. The log file says that the migration was successful, but the data in the destination record does not change. What am I doing wrong? (Migrator 7.01, Source ARS system 6.3 HUX-11 server Oracle 9.2, Destination system 7.01 patch 2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University -- Patrick Zandi Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are