Difference between revisions of "Upgrading"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (9 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | ==Upgrading | + | '''Recital Corporation recommends that program files are recompiled and indexes rebuilt whenever a new version of the software is installed.''' |
| + | |||
| + | ==Upgrading from version 9.5 to version 10== | ||
| + | |||
| + | All program files must be [[COMPILE|recompiled]] and indexes [[INDEX|rebuilt]]. To upgrade from earlier versions, tables must be [[recitalconvert|converted]] as below. | ||
| + | |||
| + | |||
| + | ==Upgrading from pre-9.5 versions== | ||
This information applies to products running on Linux (platform codes 57 and 58) ONLY. | This information applies to products running on Linux (platform codes 57 and 58) ONLY. | ||
| Line 5: | Line 12: | ||
The header information of certain Recital data tables (.dbf files) with MEMO fields needs to be updated for use under Recital 9.4 and later product lines. If you see the following message when you attempt to use a table, it needs to be converted: | The header information of certain Recital data tables (.dbf files) with MEMO fields needs to be updated for use under Recital 9.4 and later product lines. If you see the following message when you attempt to use a table, it needs to be converted: | ||
| + | |||
| + | <pre> | ||
Table must be converted for large file support. | Table must be converted for large file support. | ||
| + | </pre> | ||
| − | |||
| − | Use the [[ | + | The conversion can be done by using the [[recitalconvert]] utility. |
| + | |||
| + | Use the [[recitalconvert]] utility by issuing the following command from the operating system prompt: | ||
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert largefile <table name>.dbf |
</pre> | </pre> | ||
| Line 21: | Line 32: | ||
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert largefile |
</pre> | </pre> | ||
| − | Recital Corporation strongly recommends that you perform a full backup of your Recital applications before upgrading and converting your tables. The | + | Recital Corporation strongly recommends that you perform a full backup of your Recital applications before upgrading and converting your tables. The recitalconvert utility will attempt to backup your existing data tables prior to converting, so you will need sufficient disk space available to hold these files. The Table (.dbf) file, the Memo (.dbt) file and the Index (.dbx) file will be backed up (to a <basename>.o_dbf file, a <basename>.o_dbt file and a <basename>.o_dbx file respectively). The Data Dictionary (.dbd) is not backed up as it remains unchanged. Production tag index files are recreated by the recitalconvert process, but single index files (.ndx) will need to be rebuilt manually. |
| − | |||
| − | + | ==Upgrading from pre-9.0 versions== | |
| − | ==Upgrading | + | |
Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions. | Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions. | ||
| − | Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the [[ | + | |
| + | Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the [[recitalconvert]] utility or [[CONVERT]]. The [[recitalconvert]] utility is used from the operating system prompt: | ||
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert ver90 <table name>.dbf |
</pre> | </pre> | ||
| Line 46: | Line 56: | ||
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert ver90 |
</pre> | </pre> | ||
| − | Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. The | + | Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. The recitalconvert utility will attempt to backup your existing data tables prior to converting, so you will need sufficient disk space available to hold these files. The Table (.dbf) file, the Memo (.dbt) file and the Index (.dbx) file will be backed up (to a <basename>.o_dbf file, a <basename>.o_dbt file and a <basename>.o_dbx file respectively). The Data Dictionary (.dbd) is not backed up as it remains unchanged. Production tag index files are recreated by the recitalconvert process, but single index files (.ndx) will need to be rebuilt manually. |
| − | ==Upgrading dbx | + | ==Upgrading dbx indexes from pre-8.3 versions== |
The permissible path and filename length stored in a .dbx multiple index file was increased in Recital 8.3. | The permissible path and filename length stored in a .dbx multiple index file was increased in Recital 8.3. | ||
| Line 59: | Line 69: | ||
All multiple index files (.dbx files) must be deleted and rebuilt when upgrading from pre-Recital 8.3 versions. | All multiple index files (.dbx files) must be deleted and rebuilt when upgrading from pre-Recital 8.3 versions. | ||
| − | + | '''Example''' | |
<code lang="recital"> | <code lang="recital"> | ||
erase file company.dbx | erase file company.dbx | ||
| Line 71: | Line 81: | ||
| − | ==Upgrading | + | ==Upgrading from pre-8.0 versions== |
As part of Recital Corporation’s Year 2000 Certification Program, the Recital 8.0 release was enhanced to provide date field storage up to the Year 2270. Because of this, the database tables (.dbf files) used by the Recital 8.0 and later product lines use a different file structure to previous Recital versions. | As part of Recital Corporation’s Year 2000 Certification Program, the Recital 8.0 release was enhanced to provide date field storage up to the Year 2270. Because of this, the database tables (.dbf files) used by the Recital 8.0 and later product lines use a different file structure to previous Recital versions. | ||
| − | Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the [[ | + | Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the [[recitalconvert]] utility from the operating system prompt: |
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert year2000 <table name>.dbf |
</pre> | </pre> | ||
| Line 87: | Line 97: | ||
<pre> | <pre> | ||
| − | $ | + | $ recitalconvert year2000 |
</pre> | </pre> | ||
| − | Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. The | + | Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. The recitalconvert utility will attempt to backup your existing data tables prior to converting, so you will need sufficient disk space available to hold these files. Note that only the .dbf file will be backed up (to a <table name>.v73 file), as the Data Dictionary (.dbd) and Memo (.dbt) files remain unchanged. |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
Latest revision as of 11:54, 1 July 2010
Recital Corporation recommends that program files are recompiled and indexes rebuilt whenever a new version of the software is installed.
Contents
Upgrading from version 9.5 to version 10
All program files must be recompiled and indexes rebuilt. To upgrade from earlier versions, tables must be converted as below.
Upgrading from pre-9.5 versions
This information applies to products running on Linux (platform codes 57 and 58) ONLY.
The header information of certain Recital data tables (.dbf files) with MEMO fields needs to be updated for use under Recital 9.4 and later product lines. If you see the following message when you attempt to use a table, it needs to be converted:
Table must be converted for large file support.
The conversion can be done by using the recitalconvert utility.
Use the recitalconvert utility by issuing the following command from the operating system prompt:
$ recitalconvert largefile <table name>.dbf
or, to convert all dbf files in the current directory:
$ recitalconvert largefile
Recital Corporation strongly recommends that you perform a full backup of your Recital applications before upgrading and converting your tables. The recitalconvert utility will attempt to backup your existing data tables prior to converting, so you will need sufficient disk space available to hold these files. The Table (.dbf) file, the Memo (.dbt) file and the Index (.dbx) file will be backed up (to a <basename>.o_dbf file, a <basename>.o_dbt file and a <basename>.o_dbx file respectively). The Data Dictionary (.dbd) is not backed up as it remains unchanged. Production tag index files are recreated by the recitalconvert process, but single index files (.ndx) will need to be rebuilt manually.
Upgrading from pre-9.0 versions
Database tables (.dbf files) used by the Recital 9.0 and later product lines use a different file structure to previous Recital versions.
Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the recitalconvert utility or CONVERT. The recitalconvert utility is used from the operating system prompt:
$ recitalconvert ver90 <table name>.dbf
or, to convert all dbf files in the current directory:
$ recitalconvert ver90
Recital Corporation strongly recommends that you perform a full backup of your Recital applications upgrading and converting your tables. The recitalconvert utility will attempt to backup your existing data tables prior to converting, so you will need sufficient disk space available to hold these files. The Table (.dbf) file, the Memo (.dbt) file and the Index (.dbx) file will be backed up (to a <basename>.o_dbf file, a <basename>.o_dbt file and a <basename>.o_dbx file respectively). The Data Dictionary (.dbd) is not backed up as it remains unchanged. Production tag index files are recreated by the recitalconvert process, but single index files (.ndx) will need to be rebuilt manually.
Upgrading dbx indexes from pre-8.3 versions
The permissible path and filename length stored in a .dbx multiple index file was increased in Recital 8.3.
All multiple index files (.dbx files) must be deleted and rebuilt when upgrading from pre-Recital 8.3 versions.
Example
erase file company.dbx use company nodbx index on co_code tag code index on lower(co_name) tag name
NOTE: Recital Corporation recommends that program files are recompiled and indexes rebuilt whenever a new version of the software is installed.
Upgrading from pre-8.0 versions
As part of Recital Corporation’s Year 2000 Certification Program, the Recital 8.0 release was enhanced to provide date field storage up to the Year 2270. Because of this, the database tables (.dbf files) used by the Recital 8.0 and later product lines use a different file structure to previous Recital versions.
Therefore, before you can use your existing Recital data tables, they must be converted to the new file structure. This can be done by using the recitalconvert utility from the operating system prompt:
$ recitalconvert year2000 <table name>.dbf
or, to convert all dbf files in the current directory:
$ recitalconvert year2000
