I have done it for 3 different customers, on 5 different databases.
All the tools are there already, but it was a pretty involved process that
took a good amount of time to go through the process of converting, fixing
errors and other things that were issues, also figuring out how to get it
done over the course of a weekend for them for minimal downtime.
One of the biggest issues I had was the lack of Epicor properly checking
data size compared to field size, for example, a field that is supposed to
be limited to 30 characters wasn't being limited to 30 characters in
Progress, but when it was being transferred to SQL, SQL was enforcing the 30
character limit, so there needed to be data corrections in the original DB
ahead of time.
Also, being SQL on the backend isn't going to fix your replication problems,
you can't actually fully replicate the Epicor DB because there are so many
tables without a primary key, why they would ever make a table without a
primary key is beyond me though, that was one of the first things I learned
in HS was defining the primary key on a DB Table, while you could define
them on your own, I would caution against that since you would be changing
the schema setup by Epicor, which could technically render your DB
unsupported by them.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scotty K.
Sent: Tuesday, July 02, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] DIY - Progress to SQL
For sanity's sake, I cannot wait that long. Replication server is killing
me....
All the tools are there already, but it was a pretty involved process that
took a good amount of time to go through the process of converting, fixing
errors and other things that were issues, also figuring out how to get it
done over the course of a weekend for them for minimal downtime.
One of the biggest issues I had was the lack of Epicor properly checking
data size compared to field size, for example, a field that is supposed to
be limited to 30 characters wasn't being limited to 30 characters in
Progress, but when it was being transferred to SQL, SQL was enforcing the 30
character limit, so there needed to be data corrections in the original DB
ahead of time.
Also, being SQL on the backend isn't going to fix your replication problems,
you can't actually fully replicate the Epicor DB because there are so many
tables without a primary key, why they would ever make a table without a
primary key is beyond me though, that was one of the first things I learned
in HS was defining the primary key on a DB Table, while you could define
them on your own, I would caution against that since you would be changing
the schema setup by Epicor, which could technically render your DB
unsupported by them.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Scotty K.
Sent: Tuesday, July 02, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] DIY - Progress to SQL
For sanity's sake, I cannot wait that long. Replication server is killing
me....
On Tue, Jul 2, 2013 at 2:57 PM, Jose Gomez <jose@...> wrote:
> If you are on 9.05.XXX I'd say wait a few months... it may be a non
> issue soon...
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Tue, Jul 2, 2013 at 2:46 PM, scottyk537 <scottyk537@...> wrote:
>
> > **
> >
> >
> > Hello Everyone,
> >
> > Has anyone successfully converted their Progress database to SQL?
> > How difficult was the process? What tool did you use to convert the
database?
> > We are on version 700B x64 and our progress database is about 4GB.
> >
> > Thanks,
> > Scott
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
> )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links