Thanks,
I am at the beginning stages of migrating and will probably look
into Epicors "Fast Schema Change Package". My database is over 2 gb and any
time savers will be appreciated. I was also planning on doing everything
right on the test server, but now I think I'll configure a client pc and
take it along for the upgrade ride. Thanks again for your comments and
suggestions.
Bart Sgroi
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, November 12, 2001 12:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 3.0 to 5 conversion questions
Besides what Terry mentioned below (about turning off crash protection),
there is a legitimate "Fast Schema Change" that Epicor sent me before going
from 3 to 4 to 5, but I never used it. Just one more thing to learn at the
time, and I was overwhelmed as it was.
But if you're in the beginning stages, it might be worth looking into.
Basically Epicor can send you a "package" for the Fast Schema Changes. Then
you sort of do the schema changes one by one - typing each schema
individually (if I remember correctly). It is supposed to be much faster
that way - but I never checked to see.
Contact Epicor for more info on it.
Troy Funte
Liberty Electronics
I am at the beginning stages of migrating and will probably look
into Epicors "Fast Schema Change Package". My database is over 2 gb and any
time savers will be appreciated. I was also planning on doing everything
right on the test server, but now I think I'll configure a client pc and
take it along for the upgrade ride. Thanks again for your comments and
suggestions.
Bart Sgroi
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, November 12, 2001 12:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 3.0 to 5 conversion questions
Besides what Terry mentioned below (about turning off crash protection),
there is a legitimate "Fast Schema Change" that Epicor sent me before going
from 3 to 4 to 5, but I never used it. Just one more thing to learn at the
time, and I was overwhelmed as it was.
But if you're in the beginning stages, it might be worth looking into.
Basically Epicor can send you a "package" for the Fast Schema Changes. Then
you sort of do the schema changes one by one - typing each schema
individually (if I remember correctly). It is supposed to be much faster
that way - but I never checked to see.
Contact Epicor for more info on it.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Terry Williams
To: vantage@yahoogroups.com
Sent: Monday, November 12, 2001 11:35 AM
Subject: RE: [Vantage] 3.0 to 5 conversion questions
To do a fast schema change, start the database without crash protection.
That setting is in the procontrol configuration for the database. Best
time
to do all this is while everyone else sleeps.
Stop the database
Remove crash protection
Start the database
Run the schema change
Stop the database
Reset crash protection
Start the database
Start a vantage session
Verify the license codes
Allow the database conversion to run
End the vantage session
Stop the database
Start the database
Start a vantage session
You're on your way.
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, November 12, 2001 11:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 3.0 to 5 conversion questions
Initially (first step), you have to be at the server with the CD and
install
Vantage and progress on the Server. Next step is to go to your
Workstation,
map a drive to your dwc or dwcdlc (whichever one relates to Vantage for
3.0)
and install progress and the Vantage client using the
"vantageclientsetup.exe" icon located in your Vantage folder.
If you have to run schema changes, you can do so on the server OR the
workstation, but I think in 3.0 they were insisting you do schema changes
from a workstation. Reason? I think they didn't recommend having the
Vantage client (the ability to run Vantage) directly on the server. In
4.0
and 5.0 I don't think that's a problem and you can run the schema changes
right from the server - although it will probably slow it down
considerably.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Sgroi, Bart T.
To: 'vantage@yahoogroups.com'
Sent: Monday, November 12, 2001 11:09 AM
Subject: [Vantage] 3.0 to 5 conversion questions
Windows NT platform
I am setting up a server to do test conversions from Vantage 3.0 to 4.0
and
then on to 5. I've got the version 3 installation instructions and am
curious as to why the instructions put such an emphasis on installing
Vantage and the progress client software from the system administrators
machine. What will happen if I install vantage from the server?
What will happen if I skip the progress client install from the Sys.
Admin
workstation?
I was also wondering if anyone has any information on doing a fast
schema change when converting your database. I thought I saw a post on
it
a
while ago, but now I can't find any info on it.
Any help on either of these would be appreciated.
Bart Sgroi
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]