RRRChive may be a good choice for this as well From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Wednesday, October 02, 2013 12:16 PM 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]<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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

