DB versions & conversions

Yahoo Archive
1
For anyone else going from 3.0 to 5.0, Epicor posted a FAQ for this last night.

http://support.epicor.com/vantage

click on support in the left menu
look under Hot News for a link "For Vantage 3.00 to 5.00 FAQ click here".

John Mueske
Hiatt Manufacturing, Inc.
SBS 4.5 - Vantage 3.00.632



----- Original Message -----
From: Tim Care
To: vantage@egroups.com
Sent: Thursday, January 04, 2001 8:57 AM
Subject: Re: [Vantage] DB versions & conversions


That sounds like what I'm trying to do as well.
Remember, there is a database conversion step
between 3 and 4 that must be run before you can
login and run the v4 schema changes. Refer to the
v4 installation instructions, it should be run instead of
the step where you are restoring the 3.0 db into the
4.0 directory. Again, it is all in the v4 install instructions.
Good luck.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: "Hiatt Manufacturing, Inc." <hiattmfg@...>
To: "Vantage Egroups" <vantage@egroups.com>
Sent: Wednesday, January 03, 2001 4:57 PM
Subject: [Vantage] DB versions & conversions


> Hello all,
>
> We are currently on 3.00.632. I am trying to install 5.0 on a standalone
> workstation to start evaluating it. I cannot convert a 3.0 db directly to
a
> 5.0 db, it must be converted to 4.0 first.
>
> Fortunately, I have a 4.0 test db running alongside 3.0 on the server.
What
> is the best way to get recent 3.0 data to the 5.0 machine before
> installation (without disrupting live 3.0)? Here's my plan so far, tell me
> if I'm correct (or where I might run into a snag):
>
> 1. Run the BACKVAN.BAT utility while 3.0 is running, creating a backup.1
> file.
> 2. Turn off Proservice for 4.0.
> 3. Delete current 4.0 database files.
> 3. Run the prorest.bat command, directing the restore into the 4.0 folder.
> 4. Start Proservice for 4.0.
> 5. Logon to 4.0 & run schema changes.
> 6. Turn off Proservice for 4.0.
> 7. Burn 4.0 database files to CD.
> 8. Copy 4.0 files to standalone 5.0 machine.
> 9. Start 5.0 & run schema changes.
> 10. Evaluate.
>
> Thanks for any guidance,
>
> John Mueske
> Hiatt Manufacturing, Inc.
> SBS 4.5 - Vantage 3.00.632



eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
2
Hello all,

We are currently on 3.00.632. I am trying to install 5.0 on a standalone
workstation to start evaluating it. I cannot convert a 3.0 db directly to a
5.0 db, it must be converted to 4.0 first.

Fortunately, I have a 4.0 test db running alongside 3.0 on the server. What
is the best way to get recent 3.0 data to the 5.0 machine before
installation (without disrupting live 3.0)? Here's my plan so far, tell me
if I'm correct (or where I might run into a snag):

1. Run the BACKVAN.BAT utility while 3.0 is running, creating a backup.1
file.
2. Turn off Proservice for 4.0.
3. Delete current 4.0 database files.
3. Run the prorest.bat command, directing the restore into the 4.0 folder.
4. Start Proservice for 4.0.
5. Logon to 4.0 & run schema changes.
6. Turn off Proservice for 4.0.
7. Burn 4.0 database files to CD.
8. Copy 4.0 files to standalone 5.0 machine.
9. Start 5.0 & run schema changes.
10. Evaluate.

Thanks for any guidance,

John Mueske
Hiatt Manufacturing, Inc.
SBS 4.5 - Vantage 3.00.632
3
That sounds like what I'm trying to do as well.
Remember, there is a database conversion step
between 3 and 4 that must be run before you can
login and run the v4 schema changes. Refer to the
v4 installation instructions, it should be run instead of
the step where you are restoring the 3.0 db into the
4.0 directory. Again, it is all in the v4 install instructions.
Good luck.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: "Hiatt Manufacturing, Inc." <hiattmfg@...>
To: "Vantage Egroups" <vantage@egroups.com>
Sent: Wednesday, January 03, 2001 4:57 PM
Subject: [Vantage] DB versions & conversions


> Hello all,
>
> We are currently on 3.00.632. I am trying to install 5.0 on a standalone
> workstation to start evaluating it. I cannot convert a 3.0 db directly to
a
> 5.0 db, it must be converted to 4.0 first.
>
> Fortunately, I have a 4.0 test db running alongside 3.0 on the server.
What
> is the best way to get recent 3.0 data to the 5.0 machine before
> installation (without disrupting live 3.0)? Here's my plan so far, tell me
> if I'm correct (or where I might run into a snag):
>
> 1. Run the BACKVAN.BAT utility while 3.0 is running, creating a backup.1
> file.
> 2. Turn off Proservice for 4.0.
> 3. Delete current 4.0 database files.
> 3. Run the prorest.bat command, directing the restore into the 4.0 folder.
> 4. Start Proservice for 4.0.
> 5. Logon to 4.0 & run schema changes.
> 6. Turn off Proservice for 4.0.
> 7. Burn 4.0 database files to CD.
> 8. Copy 4.0 files to standalone 5.0 machine.
> 9. Start 5.0 & run schema changes.
> 10. Evaluate.
>
> Thanks for any guidance,
>
> John Mueske
> Hiatt Manufacturing, Inc.
> SBS 4.5 - Vantage 3.00.632