Exporting & Importing Data from SOLID : ATG

Exporting the CustomProject Data from SOLID:

Make sure that either there are no connection pool properties files, or that they are pointing to the CustomProject SOLID database. Start the SOLID database and use the commands below (on one line, with no line breaks) to export the demo data to an XML file called all.xml.

Command:

1. bin/startSQLRepository -m CustomProject -exportRepositories all all.xml

2. bin/startSQLRepository -m SampleProject -exportRepositories all all.xml

Importing the CustomProject Data to Your Database:

Your connection pool properties file must be pointing to the new target database. All Dynamo supported databases can import all.xml.

Oracle users: Before importing the CustomProject data, set the useSetCharacterStream property of all SQL repository components to true so that non-8859 characters are displayed correctly. You can set this property in your localconfig/GLOBAL.properties file: useSetCharacterStream=true

From the command line, go to the <ATGdir>/home directory. Use the commands below (on one line, with no line breaks) to import the data contained in all.xml to your target database. Your connection pool properties file must be pointing to the new target database.

Command:

1. bin/startSQLRepository -m CustomProject -import all.xml

2. bin/startSQLRepository -m  SampleProject -import all.xml


You can add your own project instead of CustomProject.