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: [email protected] Subject: Re: Moving from Oracle to SQL To: [email protected] ** 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 NallSr. Remedy Developer 7668 Warren ParkwayFrisco, TX 75034Desk: 972-464-3162Cell: 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:[email protected]] On Behalf Of Rick Cook Sent: Wednesday, October 02, 2013 11:16 AM To: [email protected] 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 <[email protected]> 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:[email protected]] On Behalf Of Nall, Roger Sent: Wednesday, October 02, 2013 9:21 PM To: [email protected] 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 NallSr. Remedy Developer 7668 Warren ParkwayFrisco, TX 75034Desk: 972-464-3162Cell: 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
