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).
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.