Your comment would have been funnier if your name was Bob. Thanks,
Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Sundberg Sent: Wednesday, October 02, 2013 2:02 PM To: [email protected] Subject: Re: Moving from Oracle to SQL ** I thought Oracle was SQL :) Funny how Microsoft usurps a standard name. -John On Wed, Oct 2, 2013 at 11:53 AM, Nall, Roger <[email protected]<mailto:[email protected]>> wrote: ** Thanks for the information, Bill. Roger A Nall Sr. Remedy Developer 7668 Warren Parkway Frisco, TX 75034 Desk: 972-464-3162<tel:972-464-3162> Cell: 973-652-6723<tel: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]<mailto:[email protected]>] On Behalf Of Bill Hoffmeier Sent: Wednesday, October 02, 2013 1:00 PM To: [email protected]<mailto:[email protected]> 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: [email protected]<mailto:[email protected]> Subject: Re: Moving from Oracle to SQL To: [email protected]<mailto:[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 Nall Sr. Remedy Developer 7668 Warren Parkway Frisco, TX 75034 Desk: 972-464-3162<tel:972-464-3162> Cell: 973-652-6723<tel: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]<mailto:[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]<mailto:[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]<mailto:[email protected]>] On Behalf Of Nall, Roger Sent: Wednesday, October 02, 2013 9:21 PM To: [email protected]<mailto:[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 Nall Sr. Remedy Developer 7668 Warren Parkway Frisco, TX 75034 Desk: 972-464-3162<tel:972-464-3162> Cell: 973-652-6723<tel: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 [email protected]<mailto:[email protected]> www.kineticdata.com<http://www.kineticdata.com/> I community.kineticdata.com<http://community.kineticdata.com/> _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

