Adding Tables to mfgsys DB

Yahoo Archive
1
The reason is that I would like the application to access just one db instead of 2 different db's


Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Jose Gomez <jose@...>
Sender: vantage@yahoogroups.com
Date: Fri, 17 Jun 2011 09:46:32
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding Tables to mfgsys DB

Epicor just updates their own tables as long as you don't have any changes
it should be fine. However the points others raise are good and you may
indeed want to be careful specially with the data corruption possibility.
Plus progress is slower than molasses going up a hill (when it wants to be)
and hard to write to. Why not use SQL or SQL Express?

*To the progress fans don't yell at me, I know it is a superior db, with
fancy functions and awesome XYZ... (it still sucks though ;-))
*
*
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:41 AM, Mike Anstey <manstey@...> wrote:

> **
>
>
> Yes you can do it, BUT to create a table you need exclusive access to
> the database which means you need to stop all app servers (and kick
> everyone out of the system) to do it. I usually create the table and
> required indexes in test, use the Data admin tool to export the file
> definition, the used the data admin tool again to import the definition
> to the live database usiing the "on-line" checkbox, which means you can
> do it with people still on the system.
>
> Once the table has been added to live, if you need to add any new
> indexes you have to get exclusive access to the database and will have
> to shut down the app servers. Indexes can't be added "on-line" for some
> reason.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, June 17, 2011 10:32 AM
>
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Adding Tables to mfgsys DB
>
> It is safe, as long as you don't start adding weird dependencies and
> stuff like that. You need to use the Progress Data Admin Tool for that.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:
>
> > **
> >
> >
> > Hi all.
> >
> > We are on epicor 9.04 with a progress database
> >
> > We developed a external application that uses ODBC to connect to
> > various tables in the DB for read only info.
> > Now we need some more custom tables but the UD tables won't do so we
> > need to add tables.
> >
> > I was wondering if its safe to add tables to mfgsys that will be used
> > only by the external application or do I need to create a separate
> > database for these tables ?
> >
> > Any help would be appreciated
> >
> > Ephraim.
> > Ephraim Feldman
> > Programmer / Analyst
> > Axis Lighting
> >
> >
>
> [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
>
>
>


- Open in Google Docs Viewer
- Open link in new tab
- Open link in new window
- Open link in new incognito window
-
- Download file
- Copy link address
- Edit PDF File on PDFescape.com


[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
2
Hi all.

We are on epicor 9.04 with a progress database

We developed a external application that uses ODBC to connect to various tables in the DB for read only info.
Now we need some more custom tables but the UD tables won't do so we need to add tables.

I was wondering if its safe to add tables to mfgsys that will be used only by the external application or do I need to create a separate database for these tables ?

Any help would be appreciated

Ephraim.
Ephraim Feldman
Programmer / Analyst
Axis Lighting
3
It is safe, as long as you don't start adding weird dependencies and stuff
like that. You need to use the Progress Data Admin Tool for that.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:

> **
>
>
> Hi all.
>
> We are on epicor 9.04 with a progress database
>
> We developed a external application that uses ODBC to connect to various
> tables in the DB for read only info.
> Now we need some more custom tables but the UD tables won't do so we need
> to add tables.
>
> I was wondering if its safe to add tables to mfgsys that will be used only
> by the external application or do I need to create a separate database for
> these tables ?
>
> Any help would be appreciated
>
> Ephraim.
> Ephraim Feldman
> Programmer / Analyst
> Axis Lighting
>
>


[Non-text portions of this message have been removed]
4
Thanks Jose for the quick reply.

I will not add any dependencies to existing tables I just need a storage space for data.

I have progress data admin and use it to create the tables.

What will happen when we upgrade to a newer version of epicor? Do I need to dump and reload the tables then?

Ephraim
Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: Jose Gomez <jose@...>
Sender: vantage@yahoogroups.com
Date: Fri, 17 Jun 2011 09:32:03
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding Tables to mfgsys DB

It is safe, as long as you don't start adding weird dependencies and stuff
like that. You need to use the Progress Data Admin Tool for that.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:

> **
>
>
> Hi all.
>
> We are on epicor 9.04 with a progress database
>
> We developed a external application that uses ODBC to connect to various
> tables in the DB for read only info.
> Now we need some more custom tables but the UD tables won't do so we need
> to add tables.
>
> I was wondering if its safe to add tables to mfgsys that will be used only
> by the external application or do I need to create a separate database for
> these tables ?
>
> Any help would be appreciated
>
> Ephraim.
> Ephraim Feldman
> Programmer / Analyst
> Axis Lighting
>
>


[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
5
While it *is* possible, consider that if the DB becomes corrupted, I doubt very much Epicor would assist in recovery if the DB structure has been altered.....

Just too easy to say whatever application you use to load data into the non vantage tables is what corrupted the db

Just my 2 cents

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> It is safe, as long as you don't start adding weird dependencies and stuff
> like that. You need to use the Progress Data Admin Tool for that.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:
>
> > **
> >
> >
> > Hi all.
> >
> > We are on epicor 9.04 with a progress database
> >
> > We developed a external application that uses ODBC to connect to various
> > tables in the DB for read only info.
> > Now we need some more custom tables but the UD tables won't do so we need
> > to add tables.
> >
> > I was wondering if its safe to add tables to mfgsys that will be used only
> > by the external application or do I need to create a separate database for
> > these tables ?
> >
> > Any help would be appreciated
> >
> > Ephraim.
> > Ephraim Feldman
> > Programmer / Analyst
> > Axis Lighting
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
6
Yes you can do it, BUT to create a table you need exclusive access to
the database which means you need to stop all app servers (and kick
everyone out of the system) to do it. I usually create the table and
required indexes in test, use the Data admin tool to export the file
definition, the used the data admin tool again to import the definition
to the live database usiing the "on-line" checkbox, which means you can
do it with people still on the system.

Once the table has been added to live, if you need to add any new
indexes you have to get exclusive access to the database and will have
to shut down the app servers. Indexes can't be added "on-line" for some
reason.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, June 17, 2011 10:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding Tables to mfgsys DB

It is safe, as long as you don't start adding weird dependencies and
stuff like that. You need to use the Progress Data Admin Tool for that.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:

> **
>
>
> Hi all.
>
> We are on epicor 9.04 with a progress database
>
> We developed a external application that uses ODBC to connect to
> various tables in the DB for read only info.
> Now we need some more custom tables but the UD tables won't do so we
> need to add tables.
>
> I was wondering if its safe to add tables to mfgsys that will be used
> only by the external application or do I need to create a separate
> database for these tables ?
>
> Any help would be appreciated
>
> Ephraim.
> Ephraim Feldman
> Programmer / Analyst
> Axis Lighting
>
>


[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
7
Epicor just updates their own tables as long as you don't have any changes
it should be fine. However the points others raise are good and you may
indeed want to be careful specially with the data corruption possibility.
Plus progress is slower than molasses going up a hill (when it wants to be)
and hard to write to. Why not use SQL or SQL Express?

*To the progress fans don't yell at me, I know it is a superior db, with
fancy functions and awesome XYZ... (it still sucks though ;-))
*
*
*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:41 AM, Mike Anstey <manstey@...> wrote:

> **
>
>
> Yes you can do it, BUT to create a table you need exclusive access to
> the database which means you need to stop all app servers (and kick
> everyone out of the system) to do it. I usually create the table and
> required indexes in test, use the Data admin tool to export the file
> definition, the used the data admin tool again to import the definition
> to the live database usiing the "on-line" checkbox, which means you can
> do it with people still on the system.
>
> Once the table has been added to live, if you need to add any new
> indexes you have to get exclusive access to the database and will have
> to shut down the app servers. Indexes can't be added "on-line" for some
> reason.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Friday, June 17, 2011 10:32 AM
>
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Adding Tables to mfgsys DB
>
> It is safe, as long as you don't start adding weird dependencies and
> stuff like that. You need to use the Progress Data Admin Tool for that.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:
>
> > **
> >
> >
> > Hi all.
> >
> > We are on epicor 9.04 with a progress database
> >
> > We developed a external application that uses ODBC to connect to
> > various tables in the DB for read only info.
> > Now we need some more custom tables but the UD tables won't do so we
> > need to add tables.
> >
> > I was wondering if its safe to add tables to mfgsys that will be used
> > only by the external application or do I need to create a separate
> > database for these tables ?
> >
> > Any help would be appreciated
> >
> > Ephraim.
> > Ephraim Feldman
> > Programmer / Analyst
> > Axis Lighting
> >
> >
>
> [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
>
>
>


- Open in Google Docs Viewer
- Open link in new tab
- Open link in new window
- Open link in new incognito window
-
- Download file
- Copy link address
- Edit PDF File on PDFescape.com


[Non-text portions of this message have been removed]
8
Thanks for the response.
I will do it anyways in test first to make sure it works.
Never good to play in live db.

Ephraim Feldman
Programmer / Analyst
Axis Lighting

-----Original Message-----
From: "Mike Anstey" <manstey@...>
Sender: vantage@yahoogroups.com
Date: Fri, 17 Jun 2011 10:41:23
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: RE: [Vantage] Adding Tables to mfgsys DB

Yes you can do it, BUT to create a table you need exclusive access to
the database which means you need to stop all app servers (and kick
everyone out of the system) to do it. I usually create the table and
required indexes in test, use the Data admin tool to export the file
definition, the used the data admin tool again to import the definition
to the live database usiing the "on-line" checkbox, which means you can
do it with people still on the system.

Once the table has been added to live, if you need to add any new
indexes you have to get exclusive access to the database and will have
to shut down the app servers. Indexes can't be added "on-line" for some
reason.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Friday, June 17, 2011 10:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Adding Tables to mfgsys DB

It is safe, as long as you don't start adding weird dependencies and
stuff like that. You need to use the Progress Data Admin Tool for that.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*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 Fri, Jun 17, 2011 at 9:29 AM, <effgroups@...> wrote:

> **
>
>
> Hi all.
>
> We are on epicor 9.04 with a progress database
>
> We developed a external application that uses ODBC to connect to
> various tables in the DB for read only info.
> Now we need some more custom tables but the UD tables won't do so we
> need to add tables.
>
> I was wondering if its safe to add tables to mfgsys that will be used
> only by the external application or do I need to create a separate
> database for these tables ?
>
> Any help would be appreciated
>
> Ephraim.
> Ephraim Feldman
> Programmer / Analyst
> Axis Lighting
>
>


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