If you want to move data from your SOLID database to the database used by your application server, you can do this using the startSQLRepository
script. This script is described in detail in the ATG Repository Guide. To use this script, follow these steps:
Set the
DYNAMO_HOME
environment variable to<ATG9dir>/home
.In the Dynamo Administration UI, create a new ATG server that uses data sources that point to the SOLID database. This is the default configuration for a new server.
Use the
startSQLRepository
script to export data from the SOLID database. Include in thestartSQLRepository
command the–s
servername
switch. For example, if the server you created in the previous step is calledserver1
, you can export the data from all of the ATG repositories using this command:bin/startSQLRepository -s server1 -exportRepositories all all.xml
Use the
startSQLRepository
script to import data from the XML file (created in the previous step) into the database used by your application server. Use the–s
switch to specify a ATG server that is configured to use a ATG data source that points to that database. For example:bin/startSQLRepository –s
server_name
-import all.xml
Note that the ATG data source must use an ATG-supported database driver. See the atg.com site for a list of supported database drivers.
Oracle users: Before importing the demo 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
Microsoft SQL users: In order to run the ATG demos with a Microsoft SQL database, you must configure the database to be case-sensitive. See your MSSQL documentation for instructions. Note that the Quincy Funds demo is not supported for MSSQL.