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"
