Exports Data From Solid Database And Imports Data into Oracle or MySQL Database : ATG

Follow this steps, 

For exporting data from Solid database and importing into Oracle | MySQL  DB's

Step 1. First time you are starting the solid database,

            copy the C:\ATG\ATG9.1\DAS\solid\atgdb\solid.db

            to

            C:\ATG\ATG9.1\DAS\solid\i486-unknown-win32\solid.db

Step 2. Double Click on the file to start solid DB:

            C:\ATG\ATG9.1\DAS\solid\i486-unknown-win32\solfe.exe.

Step 3. To export the test data from solid database to Oracle or MySQL ,

             create the file

             C:\ATG\ATG9.1\home\localconfig\atg\dynamo\service\jdbc\JTDataSource.properties

             $class=atg.service.jdbc.MonitoredDataSource
             dataSource=/atg/dynamo/service/jdbc/FakeXADataSource
             min=5
             maxFree=-1
             blocking=true
             max=10

             C:\ATG\ATG9.1\home\localconfig\atg\dynamo\service
             \jdbc\FakeXADataSource.properties

Step 4. Add these lines to use Solid database:

            driver=solid.jdbc.SolidDriver
            URL=jdbc:solid://localhost:1313

Step 5. Execute the following commands to export the test data from solid database:

             cd C:\ATG\ATG9.1\home\bin

            startSQLRepository -m PioneerCyclingJSP -export all users.xml -repository   

            /atg/userprofiling /ProfileAdapterRepository

           startSQLRepository -m PioneerCyclingJSP -export all products.xml -repository 

           /atg/commerce/catalog/ProductCatalog

Step 6. Modify the following file to use    

            C:\ATG\ATG9.1\home\localconfig\atg\dynamo\service
            \jdbc\FakeXADataSource.properties.

            Oracle database.
   
            driver=oracle.jdbc.OracleDriver
            needsSeparateUserInfo=true
            URL=jdbc:oracle:thin:@localhost:1521:atgdb
            readOnly=false
            user=scott
            password=tiger
            database=atgdb
   

            MySQL database:
   
            driver=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
            needsSeparateUserInfo=true
            URL=jdbc:mysql://localhost:3306/atgdb
            readOnly=false
            user=root
            password=root
            database=atgdb
   

Note: You may need to change the above properties depending upon the database you use.


Step 7. Execute the following command to import the test data to Oracle | MySQL database:

            cd C:\ATG\ATG9.1\home\bin

            startSQLRepository -m PioneerCyclingJSP -import users.xml -repository

            /atg/userprofiling /ProfileAdapterRepository

            startSQLRepository -m PioneerCyclingJSP -import products.xml -repository   

            /atg/commerce/catalog/ProductCatalog

Now Check your Oracle DB or MySQL DB  whether imported tables are there in your schema or not.