WCS Derby Backup

Start a command prompt session.

1. Navigate to the WCDE_installdir\bin directory.
2. Issue the following command to start an SQL session:
   

   ij.bat

3. Issue the following command to connect to the WebSphere Commerce database:
   

   connect '..\db\mall'; 

   You can now issue SQL statements that will run against your development database. Ensure that you end each of your SQL statements with a semicolon.
4. Use CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('D:/dbbackups/'); for taking back up in to the specified location.
5. To restore then use restoreFrom=<backup path>
6. EX: restoreFrom=D:/dbbackups/
7. To end your session, issue the following command: exit;