Develop > WebSphere Commerce development environment
WebSphere Commerce development database
The development environment is initially configured to work with Apache Derby, which is included with WebSphere Commerce Developer. You can configure WebSphere Commerce Developer to use the other databases.
- DB2 Universal Database for Windows, running locally or remotely.
- Oracle Database for Windows, running locally or remotely.
- DB2 for i running remotely.
For information about configuring WebSphere Commerce Developer for the preceding databases see Install WebSphere Commerce Developer.
Use different database management systems for development and production. In this case, the WebSphere Commerce enterprise bean conversion tool is used to convert the metadata of the beans from the format of the development database to that of the production database.
The Derby development database in the initial installation of WebSphere Commerce Developer has all of the starter store archives pre-published. You can publish additional stores or reset the database to its bootstrap configuration.
- Access the development database directly
You can access the development database while the test server is running or idle.
- 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.
Related concepts
WebSphere Commerce development environment
WebSphere Commerce tools and plug-ins
Related tasks
Access the development database directly
Reset the Apache Derby database to contain only bootstrap data