Vantage 8.x Progress to Epicor 9.x MS SQL, process involved?

Hey Clive,



We did our 6.1 Progress -> 9.05 Progress conversion with the assistance
of a VAR who had done this before. The process went like this:

- set up 3 test servers (virtual machines) with installs of
8.03, 9.04 and 9.05

- restore our 6.1 progress database onto the 8.03 machine

- run 8.03 admin tools on that machine & let all the automatic
upgrade conversions run (takes hours)

- repeat with 8.03 database on 9.04 machine & 9.04 database on
9.05 machine



This converts your data. We choose to re-implement our customized
reports etc because of the major changes from 6.1.



We repeated this a couple times for testing, and fought some bugs along
the way. Call me (519-944-3800 ext 294) if you want more details.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Clive
Sent: Wednesday, August 03, 2011 6:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.x Progress to Epicor 9.x MS SQL,
process involved ?





Hi Brian,

I'm very interested in how you achieved step (a) without using an Epicor
specific tools or assistance.

Is this somethign you're able to provide more info on ?.

Thanks.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Brian Roberts" <broberts@...> wrote:
>
> We did this recently and our database conversion was two stage:
>
> (a) 6.1 Progress -> 9.05 Progress (several steps, using the Epicor
> upgrade programs on a separate server).
>
> (b) 9.05 Progress -> 9.05 SQL database conversion done by Epicor. We
> decided early on to pay for one-time events like this conversion,
didn't
> investigate doing it ourselves. Ours was ~16 hours for this stage,
plus
> a couple hours transfer to & from Epicor.
>
>
>
> We didn't use DMT for any of this, but I know others have used it as
an
> alternative to the path we took.
>
>
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Clive
> Sent: Tuesday, June 28, 2011 3:43 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage 8.x Progress to Epicor 9.x MS SQL, process
> involved ?
>
>
>
>
>
> For numerous reasons when making the upgrade from Vantage 8.x with
> Progress as the db to Epicor 9 we're choosing to move over to MS SQL
as
> the db (third party apps, reporting etc).
>
> I don't see this as a complicated task, just very time consuming ?.
Also
> I'm presuming that Epicor will see this as a perfect opportunity to
sell
> their consulting services.
>
> Most of what we need is already in place, the new hardware
(ridiculously
> high specced, crazy fast storage) and the E9 licensing, I just need to
> add the MS SQL licensing and configure the server. I'm to setup and
> install the server myself, I'll need very little assistance but will
get
> the install validated before go live.
>
> So I'm presuming that the donkey work will be using the DMT, getting
the
> procedure 100% perfect so that the data can be reliably moved over at
> any point in time ?. For some background we're multi company, and
using
> Altec as well.
>
> Has anyone here been in a similar situation ?.
>
> Thanks.
>
>
>
>
>
> [Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
For numerous reasons when making the upgrade from Vantage 8.x with Progress as the db to Epicor 9 we're choosing to move over to MS SQL as the db (third party apps, reporting etc).

I don't see this as a complicated task, just very time consuming ?. Also I'm presuming that Epicor will see this as a perfect opportunity to sell their consulting services.

Most of what we need is already in place, the new hardware (ridiculously high specced, crazy fast storage) and the E9 licensing, I just need to add the MS SQL licensing and configure the server. I'm to setup and install the server myself, I'll need very little assistance but will get the install validated before go live.

So I'm presuming that the donkey work will be using the DMT, getting the procedure 100% perfect so that the data can be reliably moved over at any point in time ?. For some background we're multi company, and using Altec as well.

Has anyone here been in a similar situation ?.

Thanks.
Hi Clive,

While I haven't done it myself, I believe epicor replication will solve the problem. i.e. upgrade to E9 on progress. Replicate the Progress database to MSSQL, then reinstall E9 for MYSQL substituting your replicated database.

Hope this works. Epicor can advise.

Stephen O'Callaghan

--- In vantage@yahoogroups.com, "Clive" <clive.1972@...> wrote:
>
> For numerous reasons when making the upgrade from Vantage 8.x with Progress as the db to Epicor 9 we're choosing to move over to MS SQL as the db (third party apps, reporting etc).
>
> I don't see this as a complicated task, just very time consuming ?. Also I'm presuming that Epicor will see this as a perfect opportunity to sell their consulting services.
>
> Most of what we need is already in place, the new hardware (ridiculously high specced, crazy fast storage) and the E9 licensing, I just need to add the MS SQL licensing and configure the server. I'm to setup and install the server myself, I'll need very little assistance but will get the install validated before go live.
>
> So I'm presuming that the donkey work will be using the DMT, getting the procedure 100% perfect so that the data can be reliably moved over at any point in time ?. For some background we're multi company, and using Altec as well.
>
> Has anyone here been in a similar situation ?.
>
> Thanks.
>
Hi,

Not too sure, but are thinking about the same thing. In the past, my
understanding was that Epicor had to do the migration between Progress and SQl.

But would be interested in knowing what you discover.

Regards




________________________________
From: Clive <clive.1972@...>
To: vantage@yahoogroups.com
Sent: Tue, 28 June, 2011 8:43:24
Subject: [Vantage] Vantage 8.x Progress to Epicor 9.x MS SQL, process involved ?

Â
For numerous reasons when making the upgrade from Vantage 8.x with Progress as
the db to Epicor 9 we're choosing to move over to MS SQL as the db (third party
apps, reporting etc).

I don't see this as a complicated task, just very time consuming ?. Also I'm
presuming that Epicor will see this as a perfect opportunity to sell their
consulting services.

Most of what we need is already in place, the new hardware (ridiculously high
specced, crazy fast storage) and the E9 licensing, I just need to add the MS SQL
licensing and configure the server. I'm to setup and install the server myself,
I'll need very little assistance but will get the install validated before go
live.

So I'm presuming that the donkey work will be using the DMT, getting the
procedure 100% perfect so that the data can be reliably moved over at any point
in time ?. For some background we're multi company, and using Altec as well.

Has anyone here been in a similar situation ?.

Thanks.




[Non-text portions of this message have been removed]
We did this recently and our database conversion was two stage:

(a) 6.1 Progress -> 9.05 Progress (several steps, using the Epicor
upgrade programs on a separate server).

(b) 9.05 Progress -> 9.05 SQL database conversion done by Epicor. We
decided early on to pay for one-time events like this conversion, didn't
investigate doing it ourselves. Ours was ~16 hours for this stage, plus
a couple hours transfer to & from Epicor.



We didn't use DMT for any of this, but I know others have used it as an
alternative to the path we took.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Clive
Sent: Tuesday, June 28, 2011 3:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.x Progress to Epicor 9.x MS SQL, process
involved ?





For numerous reasons when making the upgrade from Vantage 8.x with
Progress as the db to Epicor 9 we're choosing to move over to MS SQL as
the db (third party apps, reporting etc).

I don't see this as a complicated task, just very time consuming ?. Also
I'm presuming that Epicor will see this as a perfect opportunity to sell
their consulting services.

Most of what we need is already in place, the new hardware (ridiculously
high specced, crazy fast storage) and the E9 licensing, I just need to
add the MS SQL licensing and configure the server. I'm to setup and
install the server myself, I'll need very little assistance but will get
the install validated before go live.

So I'm presuming that the donkey work will be using the DMT, getting the
procedure 100% perfect so that the data can be reliably moved over at
any point in time ?. For some background we're multi company, and using
Altec as well.

Has anyone here been in a similar situation ?.

Thanks.





[Non-text portions of this message have been removed]
Thanks for the replies everyone.

Already have the DMT so that's not an issue, just need to get MS SQL licensing from Epicor.

Of course I could get Epicor to do this all, but I have an inherent distrust of their CAM's, I don't believe anything that comes out of their mouths. If I pay for any assistance it will be with a third party specialist, in the UK Epicor's consulting costs are just far to high.

Personaly for me Progress to Progress and then to MS SQL is not an option, I need a tested and proven Progress to MS SQL process. I've no problem with it taking many hours, Vantage can be offline from the office closing on Friday to it opening on Monday.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Different databases & data migration tools but I think the principle is the same.
>
> Hopefully it isn't too much more expensive to have Epicor do the conversions. Even if it is, it might be worth it just to prevent the FUD from creeping in.
>
> BTW... I was told by a CAM that the DMT tool is only rented on a yearly basis.
>
> We did our own instead of buying paying for data conversion maps from Epicor. Personally, I really liked it because I learned so much about the database. Maybe not so great for the company... hours and wages add up pretty fast.
> But... the biggest downside I noticed is that almost everybody is suspicious of "do it yourself" imported data. People automatically attribute any bug to imported data FOREVER. It often leads to heated debates. (We went live & never had any issues related to imported data. But, several test installs were trashed along the way).
>
> BTW, I'm doing some work in E9 with "do it yourself" DMT. I've run into a few instances where they missed populating a field. Mostly little things like a description is missing. Always makes me wonder, "what else"?
>
>
>
> From Dataflo/UnitData to Vantage/Progress
> Pervasive instead of the DMT tool. (the big difference is that Pervasive doesn't consider business logic).
>
> --- In vantage@yahoogroups.com, "Clive" <clive.1972@> wrote:
> >
> > For numerous reasons when making the upgrade from Vantage 8.x with Progress as the db to Epicor 9 we're choosing to move over to MS SQL as the db (third party apps, reporting etc).
> >
> > I don't see this as a complicated task, just very time consuming ?. Also I'm presuming that Epicor will see this as a perfect opportunity to sell their consulting services.
> >
> > Most of what we need is already in place, the new hardware (ridiculously high specced, crazy fast storage) and the E9 licensing, I just need to add the MS SQL licensing and configure the server. I'm to setup and install the server myself, I'll need very little assistance but will get the install validated before go live.
> >
> > So I'm presuming that the donkey work will be using the DMT, getting the procedure 100% perfect so that the data can be reliably moved over at any point in time ?. For some background we're multi company, and using Altec as well.
> >
> > Has anyone here been in a similar situation ?.
> >
> > Thanks.
> >
>
Hi Brian,

I'm very interested in how you achieved step (a) without using an Epicor specific tools or assistance.

Is this somethign you're able to provide more info on ?.

Thanks.

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> We did this recently and our database conversion was two stage:
>
> (a) 6.1 Progress -> 9.05 Progress (several steps, using the Epicor
> upgrade programs on a separate server).
>
> (b) 9.05 Progress -> 9.05 SQL database conversion done by Epicor. We
> decided early on to pay for one-time events like this conversion, didn't
> investigate doing it ourselves. Ours was ~16 hours for this stage, plus
> a couple hours transfer to & from Epicor.
>
>
>
> We didn't use DMT for any of this, but I know others have used it as an
> alternative to the path we took.
>
>
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Clive
> Sent: Tuesday, June 28, 2011 3:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage 8.x Progress to Epicor 9.x MS SQL, process
> involved ?
>
>
>
>
>
> For numerous reasons when making the upgrade from Vantage 8.x with
> Progress as the db to Epicor 9 we're choosing to move over to MS SQL as
> the db (third party apps, reporting etc).
>
> I don't see this as a complicated task, just very time consuming ?. Also
> I'm presuming that Epicor will see this as a perfect opportunity to sell
> their consulting services.
>
> Most of what we need is already in place, the new hardware (ridiculously
> high specced, crazy fast storage) and the E9 licensing, I just need to
> add the MS SQL licensing and configure the server. I'm to setup and
> install the server myself, I'll need very little assistance but will get
> the install validated before go live.
>
> So I'm presuming that the donkey work will be using the DMT, getting the
> procedure 100% perfect so that the data can be reliably moved over at
> any point in time ?. For some background we're multi company, and using
> Altec as well.
>
> Has anyone here been in a similar situation ?.
>
> Thanks.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>