Develop > WebSphere Commerce development environment > WebSphere Commerce development database
Reset the Apache Derby database to contain only bootstrap data
The initial installation of WebSphere Commerce Developer contains pre-published starter stores using Apache Derby as the development database type. You can reset the database and workspace so that they do not contain any starter store resources. If you have enabled features, running the resetdb and resetstores scripts returns the Apache Derby database to the most recently applied fix pack level.
Procedure
- Go to the WCDE_INSTALL \bin directory.
- Run the resetdb.bat script. When prompted, confirm that to reset the database by typing YES. This script resets the database to its bootstrap configuration.
- Run the resetstores.bat script. When prompted confirm that you want the stores information in the database to be reset by typing YES. This script resets the Stores Web module in the workspace to its bootstrap configuration. After running the script, the Stores Web module does not contain starter store resources.
- Use the Administration Console to publish only those starter stores that are of interest to you.
- If applicable, perform these steps:
- If you have applied a WebSphere Commerce fix pack, run the updatedb.bat script to update the database to the appropriate level. For example,
WCDE_INSTALL\bin\updatedb.bat cloudscape
- If you have enabled features from a Feature Pack, re-enable the feature.
Enabling the feature restores data.
Related concepts
WebSphere Commerce development database
WebSphere Commerce development environment
Related tasks
Access the development database directly
Related reference