A.1 Can I import data from LocalDB to RDBMS?

Yes. However, importing data from LocalDB to RDBMS consists of two steps. First step includes exporting the data from the currently configured response read and write locations to a file. Second step includes importing the responses to RDBMS to achieve migration.

  1. Run the following:

    Windows: /webapps/sspr/WEB-INF/Command.bat

    Linux:/webapps/sspr/WEB-INF/Command.sh

    You should see an option to export response data from LocalDB.

  2. Re-run Command.bat or Command.shwith appropriate options.

    For example, Command.bat exportresponses c:\dump\<filename>

    NOTE:The file provided in the command should exist.

  3. After exporting the data, you can import all response data in to anexternal RDBMS database by using the ImportResponsesToDB command.

    For example, Command.bat ImportResponsesToDB c:\dump\<filename>

    NOTE:The file provided in the command should be the same that you used for exporting data from LocalDB.

    The Command utility uses the SSPRConfiguration.xml file to read appropriate configuration information. You should configure SSPR to connect to an RDBMS database and restart. This ensures that all required database tables are created in the RDBMS database.