I thought Oracle was SQL :)
Funny how Microsoft usurps a standard name. -John On Wed, Oct 2, 2013 at 11:53 AM, Nall, Roger <roger.na...@t-mobile.com>wrote: > ** > > Thanks for the information, Bill. **** > > ** ** > > Roger A Nall**** > > Sr. Remedy Developer**** > > ** ** > > 7668 Warren Parkway**** > > Frisco, TX 75034**** > > Desk: 972-464-3162**** > > Cell: 973-652-6723**** > > ** ** > > “You will get all you want in life, if you help enough other people get > with they want”**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Bill Hoffmeier > *Sent:* Wednesday, October 02, 2013 1:00 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Moving from Oracle to SQL**** > > ** ** > > ** **** > > Roger, > > We made this type of move here at JPL, actually merging one server that > was on MS SQL with another server using an Oracle back end. We have about > 1/4 of the data you have, but we used a combination of RRRChive and the > Migrator tool. We used Migrator to move forms and workflow, which took > about a week using a phased approach. Then we created an RRRChive job and > ran it over a weekend. After that, we synched nightly using the RRRChive > job until the cutover to production. This method worked fine for us. > > Bill > **** > ------------------------------ > > Date: Wed, 2 Oct 2013 09:23:43 -0700 > From: roger.na...@t-mobile.com > Subject: Re: Moving from Oracle to SQL > To: arslist@ARSLIST.ORG > > ** **** > > Rick,**** > > **** > > You are correct about Migrator. So far we have tried RRR Chive and > Migrator. Our best estimate is more than 4 months to move that much data. I > found an article from Microsoft. They have tool to accomplish the > conversion. I was kind of hoping someone on the List may have had some > experience and would be willing to share any information.**** > > **** > > Thanks,**** > > **** > > Roger A Nall**** > > Sr. Remedy Developer**** > > **** > > 7668 Warren Parkway**** > > Frisco, TX 75034**** > > Desk: 972-464-3162**** > > Cell: 973-652-6723**** > > **** > > “You will get all you want in life, if you help enough other people get > with they want”**** > > **** > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Rick Cook > *Sent:* Wednesday, October 02, 2013 11:16 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Moving from Oracle to SQL**** > > **** > > ** **** > > You have GOT to be kidding, Kiran. I would rather pull my own fingernails > out than use Migrator to move 1 TB of data. That utility (I won't glorify > it by calling it an application) is an antique in need of a long-overdue > re-architecture. It is reliable enough for small jobs, but I have learned > that I can't trust it to move larger chunks of anything. And on top of > that, it would take forever, and easily take up more local RAM than any box > is likely to have available.**** > > Roger, I'm thinking there is probably a tool provided by one or both of > the DBMS to accomplish this much more quickly and reliably than an > application tool could. > > Rick**** > > **** > > On Wed, Oct 2, 2013 at 9:05 AM, Hullule, Kiran <kiran_hull...@bmc.com> > wrote:**** > > ** **** > > From remedy application standpoint, you can think of using Remedy Migrator > Tool , that will take care of all data conversion from Oracle to MSSQL db. > **** > > **** > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Nall, Roger > *Sent:* Wednesday, October 02, 2013 9:21 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Moving from Oracle to SQL**** > > **** > > ** **** > > I am wondering if anyone would be willing to share their experiences with > this type of change. We have approx. 1TB of data and are looking at the > best and fastest way to move that much data.**** > > **** > > Thanks,**** > > **** > > Roger A Nall**** > > Sr. Remedy Developer**** > > **** > > 7668 Warren Parkway**** > > Frisco, TX 75034**** > > Desk: 972-464-3162**** > > Cell: 973-652-6723**** > > **** > > “You will get all you want in life, if you help enough other people get > with they want”**** > > **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > > **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > > _ARSlist: "Where the Answers Are" and have been for 20 years_**** > > _ARSlist: "Where the Answers Are" and have been for 20 years_ **** > _ARSlist: "Where the Answers Are" and have been for 20 years_ -- *John Sundberg* Kinetic Data, Inc. "Your Business. Your Process." Save the date! *KEG14* February 24-25, 2014 *For more information, click here * - KEG<http://www.kineticdata.com/Events/KEG.html> 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"