Hi Misi, Thank you for your input. Our issue is not moving forms and workflow from one server to another it is much more with the data in the forms. Thus we are looking at the available options. Using Migrator or RRR Chive are both options but I do believe there are tools available that will convert Oracle formatted data to SQL Server formatted data at the database level.
This would allow to create an ARSystem database in SQL Server to work with. The big question is what are the gotchas involved with this type of conversion. 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” -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Wednesday, October 02, 2013 6:22 PM To: [email protected] Subject: Re: Moving from Oracle to SQL Hi, I will actually be doing a presentation on Friday 10:00 at WWRUG about a new set of tools to sync your DEF-files between servers. You can already download RRR|ExportDef from our web site that will export your complete system in one go. Then you could just import that on top the freshly installed server using RRR|ImportDef (soon to be published). When you are all done you can use RRR|DefDiff to check that everything is in sync. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"

