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:[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]<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"

Reply via email to