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: [email protected]
>
> **
> 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: [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]> 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 ---
