DDL/SQL creation in atg

In the ATG FrameWork SQL/DDL can be created by just running the some scripts based on the XML Structure.There are three ways we can do it 

• Use generateSQL() in the repository component File 
• Use print-dll command 
• Use startsqlRepository.bat 

Using generateSQL:

   

Print-ddl:

Start SQL Repository:
                                   

             

StartSQLRepository -m DPS   –repository /atg/userprofiling/ProfileAdapterRepository  -outputSQLFile c:/test.sql