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"
--- Begin Message ---
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"
--- Begin Message ---
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 ---
--- End Message ---
