I am performing a database migration in order to be able to upgrade our ERP software.
Vantage is the name of the ERP software.
Progress is the database I'm using. All software has the latest service packs and hotfixes.
I started at Epicor Vantage 6.0 on a 9.1D database, then upgraded the application to Vantage 6.1 and performed a schema update on the db, using conversion tools on the ERP cd.
Then I went from version Vantage 6.1 to version Vantage 8.0 and used the conversion tools supplied on the ERP cd to go from 9.1D to 10.0B. The ERP software converted the database for me automatically.
The final step is to go from Vantage 8.0 to Vantage 8.3, the problem however is that going from Vantage 8.0 the database is 10.0B, but in Vantage 8.3 the database is 10.1B.
I need to take the 10.0B database and convert it to a 10.1B so that I can run the schema update from the Vantage 8.3 software to bring the schema from 8.0 to 8.3 using the supplied tools on the ERP software.
What I am doing is this:
I go to my 10.1B server, I attempt to restore the 10.0B database onto a 10.1B database and I get an error message.
This is the commands I type in:
I run the ProEnv program
Type in: prompt
type in: cd c:\epicor\mfgsys803\db (the location of the 803 db)
type in: prorest mfgsys c:\db\backup.3 (the location of the backup file from the 10.0B database, I did a backup to move it to the 10.1B server)
I get this error message.
"Open Edge Release 10.1B03 as of Sat Nov blab blab date goes here
This backup of a 32-bit DBKEY database contains BI or TL data.
It cannot be resotred by the 64-bit DBKEY codebase. (13732)
Use the 10.1A prorest utility to trestore the database.
!!! ERROR - Database restore utility FAILED !!! (8564)
My guess is that I need to run the proutil conv utility to convert the database from 10.0B to 10.1B. My other thoughts is that perhaps the 10.0B database is a non-unicode and the 10.1B database is unicode (hence the 32-bit to 64-bit error) I'm not sure how accurate this is. However the 6.0 Vantage 9.1 Progress was non-unicode and later releases of Vantage do support unicode.
My environment is like this: I am using VMWare to create servers where I have installed:
Server 1: Progress 9.1 to go from 6.0 Vantage to 6.1
Server 2: Progress 9.1 and 10.0B to go from vantage 6.1 to 8.0
Server 3. Progress 10.1B where I am having this issue.
I can install any combination of Progress and Vantage on any current of future VMWare server. Thanks to VMWare my test environment is limitless.
Because my knowledge of Progress is limited to this project, I don't know how to use the proutil conv command, what paramaters it takes and what it does exactly, I am hoping one of you can shed some light or point me towards the right direction.
thank you for your time.
Paul
Vantage is the name of the ERP software.
Progress is the database I'm using. All software has the latest service packs and hotfixes.
I started at Epicor Vantage 6.0 on a 9.1D database, then upgraded the application to Vantage 6.1 and performed a schema update on the db, using conversion tools on the ERP cd.
Then I went from version Vantage 6.1 to version Vantage 8.0 and used the conversion tools supplied on the ERP cd to go from 9.1D to 10.0B. The ERP software converted the database for me automatically.
The final step is to go from Vantage 8.0 to Vantage 8.3, the problem however is that going from Vantage 8.0 the database is 10.0B, but in Vantage 8.3 the database is 10.1B.
I need to take the 10.0B database and convert it to a 10.1B so that I can run the schema update from the Vantage 8.3 software to bring the schema from 8.0 to 8.3 using the supplied tools on the ERP software.
What I am doing is this:
I go to my 10.1B server, I attempt to restore the 10.0B database onto a 10.1B database and I get an error message.
This is the commands I type in:
I run the ProEnv program
Type in: prompt
type in: cd c:\epicor\mfgsys803\db (the location of the 803 db)
type in: prorest mfgsys c:\db\backup.3 (the location of the backup file from the 10.0B database, I did a backup to move it to the 10.1B server)
I get this error message.
"Open Edge Release 10.1B03 as of Sat Nov blab blab date goes here
This backup of a 32-bit DBKEY database contains BI or TL data.
It cannot be resotred by the 64-bit DBKEY codebase. (13732)
Use the 10.1A prorest utility to trestore the database.
!!! ERROR - Database restore utility FAILED !!! (8564)
My guess is that I need to run the proutil conv utility to convert the database from 10.0B to 10.1B. My other thoughts is that perhaps the 10.0B database is a non-unicode and the 10.1B database is unicode (hence the 32-bit to 64-bit error) I'm not sure how accurate this is. However the 6.0 Vantage 9.1 Progress was non-unicode and later releases of Vantage do support unicode.
My environment is like this: I am using VMWare to create servers where I have installed:
Server 1: Progress 9.1 to go from 6.0 Vantage to 6.1
Server 2: Progress 9.1 and 10.0B to go from vantage 6.1 to 8.0
Server 3. Progress 10.1B where I am having this issue.
I can install any combination of Progress and Vantage on any current of future VMWare server. Thanks to VMWare my test environment is limitless.
Because my knowledge of Progress is limited to this project, I don't know how to use the proutil conv command, what paramaters it takes and what it does exactly, I am hoping one of you can shed some light or point me towards the right direction.
thank you for your time.
Paul
