Migration from Vantage 6 to Epicor 9

You can extract it from the existing 5 or 6 database through ODBC.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dina Hieber
Sent: Wednesday, October 02, 2013 7:31 AM
To: vantage@yahoogroups.com
Subject: RE: Re: [Vantage] Migration from Vantage 6 to Epicor 9

 




Besides a database conversion, how can you get the information from 5.2/6 into excel spreadsheet to clean it up?  It is my understanding the DMT only allows you to import the information into 9.xxx, does not give you the tool to extract from older versions?

 

Best Regards,

 

Dina M. Hieber

Vamco International, Inc.

555 Epsilon Drive

Pittsburgh, PA 15238

 

(412) 963-7100 x  203

(412) 963-9511

 

www.vamcointernational.com

 

*****

This e-mail message and any files transmitted with it are confidential and are intended for the sole use of the intended receipient(s).  Any unauthorized use or disclosure is prohibited.  Any opinions express in the email are those of the individual and not necessarily the company.  If you are not the intended recipient, please contact the send by reply email and destroy all copies of the original message.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jim_chance@...
Sent: Wednesday, October 02, 2013 12:18 AM
To: vantage@yahoogroups.com
Subject: RE: Re: [Vantage] Migration from Vantage 6 to Epicor 9

 

 

Ned, have you ever done a Vantage 5 to 8.03.409c upgrade?  



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Thanks Ned and others that responded.  I thought you had to go to Vantage 8 and then 9.04, but wanted to verify.

 

Chuck Trites

chuck_trites@...

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500

 


From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 26, 2013 1:25 AM
Subject: RE: [Vantage] Migration from Vantage 6 to Epicor 9

 

 

There is no direct tool that has been written to do this that I am aware of.

 

In order to properly do the upgrade, you need to go through these steps.

 

Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.

Upgrade from 8.00 to 8.03

Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05

Upgrade 9.04 to 9.05

 

It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.

 

Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9

 

 

Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?

  

Tia,

Chuck Trites

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500

 

 

 




Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?
  
Tia,
Chuck Trites
chuck_trites@...
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500

Its been my experience that this type of jump is treated as a brand new/fresh install rather than an upgrade. As the functionality and schema changes are drastically different from 6 to 9.

www.practicaltek.com

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9

 

 

Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?

  

Tia,

Chuck Trites

chuck_trites@...

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500

Chuck, you would have to contract with Epicor directly as they write these conversion programs. I concur with what Jim said that it is such a change that you may want to consider this as a new implementation. I have done a Vantage 6 to E9 (SQL) conversion so if you want to discuss let me know

From: Chuck Trites <chuck_trites@...>
To: Vantage list <vantage@yahoogroups.com>
Sent: Wednesday, September 25, 2013 4:16 PM
Subject: [Vantage] Migration from Vantage 6 to Epicor 9
 
Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?
  
Tia,
Chuck Trites
chuck_trites@...
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500

There is no direct tool that has been written to do this that I am aware of.

 

In order to properly do the upgrade, you need to go through these steps.

 

Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.

Upgrade from 8.00 to 8.03

Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05

Upgrade 9.04 to 9.05

 

It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.

 

Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9

 




Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?

  

Tia,

Chuck Trites

chuck_trites@...

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500




We are doing the same process on the cheap. We have hired Epicor to update our 6.1 database to 9.05.702A with two passes. Right now we are on the first pass running in duplicate on 6.1 & 9.05.702A. When we feel comfortable we do the second pass of the 6.1 database and go live on 9.05.702A

Terry



---In vantage@yahoogroups.com, <TechnoBabbly@...> wrote:

There is no direct tool that has been written to do this that I am aware of.

 

In order to properly do the upgrade, you need to go through these steps.

 

Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.

Upgrade from 8.00 to 8.03

Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05

Upgrade 9.04 to 9.05

 

It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.

 

Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9

 




Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?

  

Tia,

Chuck Trites

chuck_trites@...

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500




Thanks Ned and others that responded.  I thought you had to go to Vantage 8 and then 9.04, but wanted to verify.
 
Chuck Trites
chuck_trites@...
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500


From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 26, 2013 1:25 AM
Subject: RE: [Vantage] Migration from Vantage 6 to Epicor 9

 
<div id="ygrps-yiv-1476670984yiv0339364647ygrp-text">
  
  
  <div class="ygrps-yiv-1476670984yiv0339364647WordSection1"><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">There is no direct tool that has been written to do this that I am aware of.</span></div><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">In order to properly do the upgrade, you need to go through these steps.</span></div><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.</span></div><div class="ygrps-yiv-1476670984yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade from 8.00 to 8.03</span></div><div

class=“ygrps-yiv-1476670984yiv0339364647MsoNormal”>Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05

Upgrade 9.04 to 9.05
 
It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth
the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.
 
Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9
 



Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?
  
Tia,
Chuck Trites
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500



</div>


Ned, have you ever done a Vantage 5 to 8.03.409c upgrade?  



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Thanks Ned and others that responded.  I thought you had to go to Vantage 8 and then 9.04, but wanted to verify.
 
Chuck Trites
chuck_trites@...
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500


From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 26, 2013 1:25 AM
Subject: RE: [Vantage] Migration from Vantage 6 to Epicor 9

 
<div id="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647ygrp-text">
  
  
  <div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647WordSection1"><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">There is no direct tool that has been written to do this that I am aware of.</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">In order to properly do the upgrade, you need to go through these steps.</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade from 8.00 to 8.03</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Upgrade 9.04 to 9.05</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</span></div><div class="ygrps-yiv-1176646938ygrps-yiv-14162158yiv0339364647MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth

the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.

 
Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9
 



Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?
  
Tia,
Chuck Trites
Trites Consulting, Inc.
181 Hillcrest Drive
Laconia, NH 03246
Phone: (603) 219-1500



</div>


No, I have not gone that far back.

 

I assume you would just update from 5 to 6 and then follow the path to 8.03.

 

You could try going straight from 5 to 8.0 and see what happens but I am not sure how it would go, the schema changes are there, and logically the conversions should work, but I have no actual knowledge of whether they will or what the outcome would be.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jim_chance@...
Sent: Wednesday, October 02, 2013 12:18 AM
To: vantage@yahoogroups.com
Subject: RE: Re: [Vantage] Migration from Vantage 6 to Epicor 9

 




Ned, have you ever done a Vantage 5 to 8.03.409c upgrade?  



---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Thanks Ned and others that responded.  I thought you had to go to Vantage 8 and then 9.04, but wanted to verify.

 

Chuck Trites

chuck_trites@...

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500

 


From: Ned <TechnoBabbly@...>
To: vantage@yahoogroups.com
Sent: Thursday, September 26, 2013 1:25 AM
Subject: RE: [Vantage] Migration from Vantage 6 to Epicor 9

 

 

There is no direct tool that has been written to do this that I am aware of.

 

In order to properly do the upgrade, you need to go through these steps.

 

Upgrade from 6.1 to 8.00, this involves standard schema and conversions, as well as a special task to upgrade the DB from Progress 9 to OpenEdge 10.

Upgrade from 8.00 to 8.03

Upgrade 8.03 to 9.04 – this step can be done with the DUU which is part of the 32-bit version of Epicor 9.05

Upgrade 9.04 to 9.05

 

It is a long process, that can have a lot of hiccups, many things can be fixed in the end with Updatable dashboards and the DMT tool, however it has been my experience that like other people have said, the massive changes from one to the other is pretty extreme, and while a customer who may have followed this same path over the course of 10 years or so might be just fine, making the jump all at once can be a daunting task where the time and effort isn’t worth the end result. Many customers take this opportunity to step back, re-evaluate their entire process, and do a complete re-implementation which can allow for a cleansing of old non-relevant data, clean up messy data, and give yourself a more efficient database than you could end up with by going through the upgrade process.

 

Regardless of what you end up doing, I usually recommend that everyone at least do a test upgrade of their database so they can see how their database will actually handle the upgrade process.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chuck Trites
Sent: Wednesday, September 25, 2013 4:16 PM
To: Vantage list
Subject: [Vantage] Migration from Vantage 6 to Epicor 9

 



Are there any tools for migrating from a Vantage 6 (Progress) environment to a Epicor 9 (SQL) environment?

  

Tia,

Chuck Trites

Trites Consulting, Inc.

181 Hillcrest Drive

Laconia, NH 03246

Phone: (603) 219-1500