Re: Regarding MS SQL Server to Oracle Migration

[Jan Lindhardsen]

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 beauty, in my opinion, is that you can run the tool over and over again, to 
do delta data migrations, So, say that your initial transfer will take 2 days, 
then the subsequent runs will take hours, minutes or seconds, potentially 
minimising you downtime at the time of the actual upgrade/migration.

Good luck in you migration!

/Jan

> On 5 Mar 2018, at 16:53, Vinod Gaidhani  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

Re: Regarding MS SQL Server to Oracle Migration

[Sean Harries]

Hi Radhika,

Thanks for the question, the Alderstone CMT does indeed migrate from
non-unicode SQL Server to unicode SQL Server, with no issues. I agree with
other arslist posts, don't let the DB Migration convert to Unicode, there
are generally issues and you are of course right, 400Gb through the Java
API would be very slow.

I would suggest you use our Customer Move Tool (more info
http://www.alderstone.com/cmt) for the migration from previous ITSM
versions to the latest, regardless of database version or non-unicode. We
can migrate all modules and data, or a reduced set (including extracting
single companies and migrating just their data), depending on your
requirements. In general, we've been able to move all data within one day
and the upgrade process becomes very smooth indeed. Please let me know if
you would like to talk about this in more detail or I can set up a Demo of
our migration tool to show you the flexibility and power of the application.

In the mean time, if you have specific questions around upgrades, please
let me know.


regards


Sean


*Sean Harries*
Alderstone Consulting Ltd


Revolutionise your management of BMC Remedy ITSM Services with CMT
<http://alderstone.com/cmt/>

Mobile: +44 (0)7976 558048
Skype: seanharries
MSN: seanharr...@alderstone.com 
e-mail: sean.harr...@alderstone.com
Linkedin: http://www.linkedin.com/in/seanharries


On 7 March 2018 at 13:13, Narayanan, Radhika 
wrote:

> Hi,
>
>
>
> Is Alderstone CMT DB Migration solution also capable of migrating data
> from non-unicode SQL Server to Unicode SQL Server ?
>
>
>
> Previous arlist posts recommend not to carry out DB migration to convert
> non-unicode to Unicode, instead install AR fresh with unicode and then use
> Java API 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 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 database
> particulars.
>
>
>
> We had one customer who spent 12 months trying to develop and model the
> Remedy data model, after which they reached out to us and we were able to
> migrate from SQL to Oracle in a couple of months.
>
>
>
> Let me know if this is of interest. Feel free to reach out.
>
>
>
> Thanks
>
> Mohamed
>
>
>
> ——
> Mohamed Kamruzzaman
> Alderstone Consulting
>
> Personal Meeting Room
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.gotomeet.me_MohamedK&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=PJgHhISHBNp0-B23zPGhrUJyfqOlAe0g_nFGqrVRkBg&e=>
>
> mobile: +1 650 308 4633 <(650)%20308-4633>
> skype: mkamruzzaman
> email: mohamed.kamruzza...@alderstone.com
>
> Revolutionise your management of BMC Remedy ITSM Services with CMT
> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.alderstone.com_cmt.html&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=K4usLoBN_RbCj7v40ou9gr_ASjRrs6s49nwFNEpyDL8&e=>
>
>
>
> On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
> 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
> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.alderstone.com_&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=QatyqJWmQcX1B2mhKGTC7l5f03P6jS3ENSXUouMR6kk&e=>
>
>
>
>
>
>
>
> On 5 Mar 2018 4:55 pm, "Vinod Gaidhani"  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 handle

RE: Regarding MS SQL Server to Oracle Migration

[Narayanan, Radhika]

Hi,

Is Alderstone CMT DB Migration solution also capable of migrating data from 
non-unicode SQL Server to Unicode SQL Server ?

Previous arlist posts recommend not to carry out DB migration to convert 
non-unicode to Unicode, instead install AR fresh with unicode and then use Java 
API 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 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 database particulars.

We had one customer who spent 12 months trying to develop and model the Remedy 
data model, after which they reached out to us and we were able to migrate from 
SQL to Oracle in a couple of months.

Let me know if this is of interest. Feel free to reach out.

Thanks
Mohamed

——
Mohamed Kamruzzaman
Alderstone Consulting
Personal Meeting 
Room<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.gotomeet.me_MohamedK&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=PJgHhISHBNp0-B23zPGhrUJyfqOlAe0g_nFGqrVRkBg&e=>
mobile: +1 650 308 4633
skype: mkamruzzaman
email: 
mohamed.kamruzza...@alderstone.com<mailto:mohamed.kamruzza...@alderstone.com>

Revolutionise your management of BMC Remedy ITSM Services with 
CMT<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.alderstone.com_cmt.html&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=K4usLoBN_RbCj7v40ou9gr_ASjRrs6s49nwFNEpyDL8&e=>

On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
mailto:gcoleman.arsl...@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<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.alderstone.com_&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=QatyqJWmQcX1B2mhKGTC7l5f03P6jS3ENSXUouMR6kk&e=>



On 5 Mar 2018 4:55 pm, "Vinod Gaidhani" 
mailto:vinod.gaidh...@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<mailto:ARSList@arslist.org>
https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwMFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=bm1W-REkmgQ5toMOlxQyxzI1KM2JkM-EMKoNN38sFEU&e=>
--
ARSList mailing list
ARSList@arslist.org<mailto:ARSList@arslist.org>
https://mailman.rrr.se/cgi/listinfo/arslist<https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist&d=DwQFaQ&c=H50I6Bh8SW87d_bXfZP_8g&r=blQKSsGpUV3vEddB0ufOi2izy5lUOikNQGO3le4xQkw&m=bMlqLRT9Ee7IhpV1CE6-bdQC_HNR1Hwu3qPs53-YlVA&s=bm1W-REkmgQ5toMOlxQyxzI1KM2JkM-EMKoNN38sFEU&e=>

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

Re: Regarding MS SQL Server to Oracle Migration

[Vinod Gaidhani]

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 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 9:05 AM, Mohamed Kamruzzaman  alderstone.com> wrote:
>
>> 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 database
>> particulars.
>>
>> We had one customer who spent 12 months trying to develop and model the
>> Remedy data model, after which they reached out to us and we were able to
>> migrate from SQL to Oracle in a couple of months.
>>
>> Let me know if this is of interest. Feel free to reach out.
>>
>> Thanks
>> Mohamed
>>
>> ——
>> Mohamed Kamruzzaman
>> Alderstone Consulting
>> Personal Meeting Room 
>> mobile: +1 650 308 4633 <(650)%20308-4633>
>> skype: mkamruzzaman
>> email: mohamed.kamruzza...@alderstone.com
>>
>> Revolutionise your management of BMC Remedy ITSM Services with CMT
>> 
>>
>> On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
>> 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"  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
>>
>>
>>
>> --
>> 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
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Regarding MS SQL Server to Oracle Migration

[Randeep Atwal]

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 9:05 AM, Mohamed Kamruzzaman <
mohamed.kamruzza...@alderstone.com> wrote:

> 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 database
> particulars.
>
> We had one customer who spent 12 months trying to develop and model the
> Remedy data model, after which they reached out to us and we were able to
> migrate from SQL to Oracle in a couple of months.
>
> Let me know if this is of interest. Feel free to reach out.
>
> Thanks
> Mohamed
>
> ——
> Mohamed Kamruzzaman
> Alderstone Consulting
> Personal Meeting Room 
> mobile: +1 650 308 4633 <(650)%20308-4633>
> skype: mkamruzzaman
> email: mohamed.kamruzza...@alderstone.com
>
> Revolutionise your management of BMC Remedy ITSM Services with CMT
> 
>
> On 5 Mar 2018, at 6:03 PM, Gavin Coleman 
> 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"  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
>
>
>
> --
> 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

Re: Regarding MS SQL Server to Oracle Migration

[Mohamed Kamruzzaman]

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 database particulars.

We had one customer who spent 12 months trying to develop and model the Remedy 
data model, after which they reached out to us and we were able to migrate from 
SQL to Oracle in a couple of months. 

Let me know if this is of interest. Feel free to reach out. 

Thanks
Mohamed

——
Mohamed Kamruzzaman
Alderstone Consulting
Personal Meeting Room 
mobile: +1 650 308 4633
skype: mkamruzzaman
email: mohamed.kamruzza...@alderstone.com 


Revolutionise your management of BMC Remedy ITSM Services with CMT 


> On 5 Mar 2018, at 6:03 PM, Gavin Coleman  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"  > 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

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

Re: Regarding MS SQL Server to Oracle Migration

[Vinod Gaidhani]

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 
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"  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
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Regarding MS SQL Server to Oracle Migration

[Gavin Coleman]

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 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