Vantage 8 Conversion

Vantage 6.1 to 8 Conversion does NOT do a dump/load. Converting your pre-8 database to Unicode, which new installs already are, will
rebuild the indexes but also doesn't do a dump/load. We use a 6.0 Dump/Load kit with the 4k block-size recommended for Windows OS
before the conversion to 6.1. We're staying on 6.0 because the Epicor custom development we paid for can be done with 8.0's
Customization.

----- Original Message -----
From: "Todd Caughey" <caugheyt@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, November 22, 2005 10:39 AM
Subject: RE: [Vantage] Database defragmentation


I' ve done dump & reload several times after corruption and repair issues. It takes awhile (for our 1.4GB DB). First
rule....multiple backups on a variety of media. I also vaguely recall a dump & reload somewhere in the 4.0 to 5.2 upgrade path due
to some heavy duty schema changes. It's one of those nail-biter processes where it runs and runs and you are never sure if it is
really getting anywhere except for occasional messages. I never really noticed any performance improvement but then I was more
interested in the DB running again at all.

For drive fragmentation I think touching the Progress DB (running or not) would be very dangerous. But perhaps Tech Support could
advise about doing this in between the dump and the reload with something like Raxco or Diskeeper. As long as you are going part
way it might be a good chance to re-org the physical drive along the way - unless TS thinks it too risky. Perhaps having the DB
physically contiguous (for awhile) could be a speed benefit. Or maybe Prorest is smart enough about grabbing contiguous free space
and you could accomplish that with that method (although that method won't address DB internal optimization so you really might need
both or all three - dump/reload + Backup/Restore with physical defrag in between).

If anyone has solid performance info on any of this please post.

Also.....does the movement of data to 8.0 amount to a dump/reload? If so I will wait for that and since it will be on a virgin
system the physical drive issue should be good too.

-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Edward F. Fox, Jr.
Sent: Tuesday, November 22, 2005 12:18 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database defragmentation


I believe "dump and reload" is what you are looking for.

I have never performed on before, I think support has the info you need.


Edward F. Fox, Jr. CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 * Fax 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Wojewoda
Sent: Tuesday, November 22, 2005 1:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database defragmentation

Sorry I forgot to put that info in.

V 6.1 Progress - any utility that will work and defragment my never
defragmented DB (never means from day 1, and we're a DCD company)

Thomas Wojewoda

IS Manager

Principal Manufacturing Corp.

2800 South 19th Ave.

Broadview, IL 60155

http://www.principalmfg.com

ph. (708) 865 7500

fx. (708) 865 7632

cl. (708) 259 4864

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Michael Barry
Sent: Tuesday, November 22, 2005 12:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database defragmentation

Are we talking Progress, SQL Server, external file defrag utility, internal
utility?????

Michael

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Thomas Wojewoda
Sent: Tuesday, November 22, 2005 10:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database defragmentation

Is there any good way of running a defrag of the DB without being worried
that something will crash, blowup, burn, melt or sustain deadly damage?

Thomas Wojewoda
IS Manager
Principal Manufacturing Corp.
2800 South 19th Ave.
Broadview, IL 60155
http://www.principalmfg.com < http://www.principalmfg.com/> ph. (708) 865
7500 fx. (708) 865 7632 cl. (708) 259 4864



********************
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you.





[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
Yahoo! Groups Links











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
Yahoo! Groups Links









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
Yahoo! Groups Links









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




SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
database software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
management software Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>
marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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




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
Yahoo! Groups Links