Page 1 of 1

Oracle Database migration from one user to another ?

PostPosted: Wed Dec 28, 2005 8:09 pm
by 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

PostPosted: Mon Jan 09, 2006 8:52 am
by 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.

PostPosted: Fri Jan 20, 2006 5:31 pm
by 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

PostPosted: Sun Jan 22, 2006 2:43 am
by 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