This content has been marked as final. Show 5 replies
Any idea on how to generate sql insert scripts from data xmls.
Thanks in advance.
Do you know about StartSqlRepository . Check the following links.
Thanks for reply..
I have checked the startSQLRepository script by using this we can export or import repository data from xml to repository.But in startSQLRepository there is no attribute to generate sql
insert scripts from data xmls but there is a option to get the sql scripts(-ouputSQL).
When u do repository.additem(item). Repository create the insert script . Why you need to generate the insert scripts?
enable loggingDebug on repository component (in your case /atg/userprofiling/ProfileAdapterRepository).
Also make sure you are starting fresh i.e you should not have the item created already in which case it will update the item and you will see update query instead.