Re: Regarding MS SQL Server to Oracle Migration

Subject: Re: Regarding MS SQL Server to Oracle Migration

From: Vinod Gaidhani <vinod.gaidhani@gmail.com>

Date: Mon, 5 Mar 2018 10:52:42 -0600

Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=DJWF6vrYAADDX6N7c013VG6xvB1Wj7e3RGySp6zM9tY=; b=GOQfwkrnRG0/foETl3M86AsBiEvRB28vMcZmMQgu3qfjGgCpF5+jlNk+IbnwN5bnSo s7JgSe+3zD5xIPiVfBuYaxVLK/O+Ms5mGr8E1WqQJ4yI7XVR9WfpixTa1X7Cs65aHP42 trykhadCgVrJoqb2UTZDFgm3tDYwoG+HypWBjzADcQFakYgZ39+LBZIZeFqSrDJS/5Zw npr2hHTpibHzyfMOCfl2fdYEaNEIcdvYiiTpyN342B+gDaOaWQRqTW9ZS6TATjCjqi/W Zd3w9UrCKm+hEVptwmbuSV7Iy8eY0lq9chI4AVZmbo5H7VBOEH62bsppyboJfwXBcoun yBFA==

In-reply-to: <CACt7KfM-kO2B7a3EchF960TUKSXo0tGk=O1EsYdJCyUbkjVzzQ@mail.gmail.com>

List-archive: <https://mailman.rrr.se/arslist/>

List-help: <mailto:arslist-request@arslist.org?subject=help>

List-id: ARSList <arslist.arslist.org>

List-post: <mailto:arslist@arslist.org>

List-subscribe: <https://mailman.rrr.se/cgi/listinfo/arslist>, <mailto:arslist-request@arslist.org?subject=subscribe>

List-unsubscribe: <https://mailman.rrr.se/cgi/options/arslist>, <mailto:arslist-request@arslist.org?subject=unsubscribe>

References: <CAABUMPDPLq5_8AR-eHQibJ9FgbEiFouTnjddH-RJVGWfxQ7PGA@mail.gmail.com> <CACt7KfM-kO2B7a3EchF960TUKSXo0tGk=O1EsYdJCyUbkjVzzQ@mail.gmail.com>

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.

Thanks,

Vinod Gaidhani.

On Mon, Mar 5, 2018 at 10:03 AM, Gavin Coleman <gcoleman.arslist@gmail.com> wrote:

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" <vinod.gaidhani@gmail.com> wrote:
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 the way data handled in both databases [for LOBs/etc]

We have explored multiple tools which handles this at API level but 650GB data seems to be lot to be handled and verify by any tools out there.

Thanks,
Vinod Gaidhani.

--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist