Re: Regarding MS SQL Server to Oracle Migration

I’ve done this on a couple of occasions, using Misi’s RRRchive utility, which of course does everything on the API/Application level, and therefore takes more time. https://rrr.se/cgi/index?pg=chive I have not used it on 650GB, but at least on 150++. The

Re: Regarding MS SQL Server to Oracle Migration

alf Of *Mohamed > Kamruzzaman > *Sent:* Monday, March 05, 2018 10:35 PM > *To:* ARSList > *Subject:* Re: Regarding MS SQL Server to Oracle Migration > > > > Hi Vinod, > > > > Hope you are well. This is a scenario we have helped many customers with. >

RE: Regarding MS SQL Server to Oracle Migration

to migrate data. However, to migrate ~400 GB data through Java API will need many months of time ! Thanks, Radhika Narayanan From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Mohamed Kamruzzaman Sent: Monday, March 05, 2018 10:35 PM To: ARSList Subject: Re: Regarding MS SQL Server to Oracle

Re: Regarding MS SQL Server to Oracle Migration

Thanks Mohamed for the details. Randeep, Thanks for your suggestion but I think until BMC marks it supported, no customer would opt for this option. Thanks, Vinod Gaidhani. On Mon, Mar 5, 2018 at 6:00 PM, Randeep Atwal wrote: > I have nothing against Oracle, but just

Re: Regarding MS SQL Server to Oracle Migration

I have nothing against Oracle, but just thought I'd mention that you could maybe look into running SQL Server 2017 since it's now available for Linux as well as Windows, if your DBA's are ready for it. Remedy 9.x uses JDBC drivers to connect to the DB so it might be ok. On Mon, Mar 5, 2018 at

Re: Regarding MS SQL Server to Oracle Migration

Hi Vinod, Hope you are well. This is a scenario we have helped many customers with. As Gavin mentioned the Alderstone CMT solution can migrate data from MSSQL to Oracle at the database level maintaining all relationships and data integrity as well as doing all necessary conversation for the

Re: Regarding MS SQL Server to Oracle Migration

Thanks Gavin, I have gone through multiple products. Alderstone's CMT seems to be idle but tools procurement is really a big process. So looking for any experiences who have performed this with the help of DBA's and if any issues/risk for doing same. Biggest issue seems to be how LOBs are handled.

Re: Regarding MS SQL Server to Oracle Migration

Have you looked at Alderstone's CMT product? I've used this before and can recommend it. It's blindingly fast and can perform data transformation as well. https://www.alderstone.com On 5 Mar 2018 4:55 pm, "Vinod Gaidhani" wrote: > Hi Team, > > We are planning to

Regarding MS SQL Server to Oracle Migration

Hi Team, We are planning to migrate from Microsoft to Linux [8.1 to 9.1] and as part of this, we will have to move to Oracle as well. Can anyone please share approach/experience of doing this at Database level using DBA utilities. Or there is no otherways but do it at API level only because of