Difference between revisions of "Database Schema Upgrade"
(initial content, upgrade schema steps) |
(note on why to change) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | If you originally install AbleCommerce using SQL Server 2000 and later upgrade your database platform to SQL Server 2005 or later, you may need to upgrade your database schema. This upgrade is to convert database structures that take advantage of newer features in SQL Server, such as the nvarchar(max) field. | + | If you originally install AbleCommerce using SQL Server 2000 and later upgrade your database platform to SQL Server 2005 or later, you may need to upgrade your database schema. This upgrade is to convert database structures that take advantage of newer features in SQL Server, such as the nvarchar(max) field. The changes are intended to make the database use more efficient storage mechanisms and have better performance overall. |
Schema upgrade scripts are only available for AC7.0.3 and later. To see whether you require a schema upgrade, go to the Help -> About page in your merchant menu. In the version listing, the version of SQL Server and the version of the AC schema are listed: | Schema upgrade scripts are only available for AC7.0.3 and later. To see whether you require a schema upgrade, go to the Help -> About page in your merchant menu. In the version listing, the version of SQL Server and the version of the AC schema are listed: | ||
| − | <blockquote>MSSQL v2005 | + | <blockquote>MSSQL v2005<br /> |
AC SCHEMA v2000</blockquote> | AC SCHEMA v2000</blockquote> | ||
This would be an example of an installation that should proceed with the schema upgrade. Note that SQL Server is 2005, while the schema remains at 2000 level. To bring AC SCHEMA up to the 2005 level, follow the steps below: | This would be an example of an installation that should proceed with the schema upgrade. Note that SQL Server is 2005, while the schema remains at 2000 level. To bring AC SCHEMA up to the 2005 level, follow the steps below: | ||
| − | + | # Create a folder named "Install" in the AbleCommerce installation location | |
| − | + | # Place the files for the upgrade schema script | |
| − | + | # Manually access the upgrade script (<nowiki>http://your_url/Install/UpgradeSchema.aspx</nowiki>) | |
| − | + | # MAKE A BACKUP OF YOUR DATABASE | |
| − | + | # Confirm the backup and submit the request to upgrade the schema | |
| + | |||
| + | == Backup == | ||
| + | This upgrade involves major alteration to the structures of your tables. Use SQL Management Studio to make a full backup of your database prior to executing the schema upgrade. If you do not make a backup, you will have no way to recover in the event of an unexpected problem. It is NOT an optional step. | ||
== Script Locations == | == Script Locations == | ||
| − | + | [http://bugs.ablecommerce.com/attachment.cgi?id=2256 Upgrade Script for AC703] | |
Upgrade scripts are also included with the full distribution in the "Install" folder. | Upgrade scripts are also included with the full distribution in the "Install" folder. | ||
| + | |||
| + | == External References == | ||
| + | [http://bugs.ablecommerce.com/show_bug.cgi?id=7924 Bug 7924: Database Schema Upgrade Script should recognize and adjust to SQL versions] | ||
| + | |||
| + | [[Category:Merchant User Guide]] | ||
Latest revision as of 18:44, 18 August 2009
If you originally install AbleCommerce using SQL Server 2000 and later upgrade your database platform to SQL Server 2005 or later, you may need to upgrade your database schema. This upgrade is to convert database structures that take advantage of newer features in SQL Server, such as the nvarchar(max) field. The changes are intended to make the database use more efficient storage mechanisms and have better performance overall.
Schema upgrade scripts are only available for AC7.0.3 and later. To see whether you require a schema upgrade, go to the Help -> About page in your merchant menu. In the version listing, the version of SQL Server and the version of the AC schema are listed:
MSSQL v2005
AC SCHEMA v2000
This would be an example of an installation that should proceed with the schema upgrade. Note that SQL Server is 2005, while the schema remains at 2000 level. To bring AC SCHEMA up to the 2005 level, follow the steps below:
- Create a folder named "Install" in the AbleCommerce installation location
- Place the files for the upgrade schema script
- Manually access the upgrade script (http://your_url/Install/UpgradeSchema.aspx)
- MAKE A BACKUP OF YOUR DATABASE
- Confirm the backup and submit the request to upgrade the schema
Backup
This upgrade involves major alteration to the structures of your tables. Use SQL Management Studio to make a full backup of your database prior to executing the schema upgrade. If you do not make a backup, you will have no way to recover in the event of an unexpected problem. It is NOT an optional step.
Script Locations
Upgrade scripts are also included with the full distribution in the "Install" folder.
External References
Bug 7924: Database Schema Upgrade Script should recognize and adjust to SQL versions
