Oracle Database migration from one user to another ?

[harinder_kaur]

Hi All!

i have two oracle database users in same compiere database.

suppose one is
username:test
passsword:test
database name:compiere

and second one is
username:dev
passsword:dev
database name:compiere


dev/dev@compiere is working properly at client side.they have made some entries in that user.
Client wanted some changes in compiere GUI as well as in some functionality.

we have made that changes in test/test@compiere and it is working properly.

Problem is how can i import the new data (rows from Application dictionary as well as new tables and some modification in original old tables) into dev/dev@compiere without affecting their buisness process( old database entries).

Thanks and Regards,
Harinder kaur

[red1]

This may exactly be the challenge for the Compilo project at http://compilo.sf.net/ There u can find out about the XML2AD by Marco LOMBARDO which does the transfer of AD Changes from one instance to another.

[harinder_kaur]

Thanks !

This tool is working fine. i have tested using given examples.
i have created a new table c_lead.
But how can i create a view.xml amd xml2ad.xml for c_lead table?
is druid helpful in this case?
if yes then how?

Thanks and Regards
Harinder kaur

[trifon]

Hi Harinder,

Druid can generate model.xml, alterTable.sql, createTable.sql, but view.xml at the moment is created manualy.

Please read PDF document writen by Red1, there you will find usefull information.

Regards,
Trifon