Best way to migrate data dictionary from development to prod

For those who got the Open Source fever, sharing only makes you hot!

Moderator: neilg

Best way to migrate data dictionary from development to prod

Postby neilg » Mon Jun 27, 2005 10:40 pm

I was just involved in (another) move of changes (windows, tables, columns, elements, fields, processes.)

First I've tried various shortcuts like exporting the columns to try and save time. I've always landed up going back and just doing it manually.

Looked at XML2AD but was too tired to give it a good go.

So my advice for now is: do it manually
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby neilg » Mon Jun 27, 2005 10:43 pm

However there are some scripts if you're running on Oracle that ease the process. Not sure if they come standard with Compiere or not the one, you need to create the ad_table record first. Then you can run a script which copies the common fields. Then run the process 'Create fields from table'.

This helps quite a bit, and you also keep the SQL script which created your table on the dev system and re-run it on the live.
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby red1 » Tue Jun 28, 2005 7:25 am

The steps described by Neilis exactly what Druid and XML2AD accomplishes. I will rush my tutorial and publish here and at compilo.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby neilg » Tue Jun 28, 2005 1:16 pm

Thanks Red1, it would've saved me the best part of a day yesetrday which I spent recreating AD changes.

Look forward to it.
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby red1 » Thu Jun 30, 2005 12:04 am

Here it is Neil:

http://red1.org/compiere/XML2AD.zip

Its the first easy draft. I will upload it to compilo later.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby trifon » Thu Jun 30, 2005 12:22 am

Is it the latest one, that i have developed?

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

Postby neilg » Thu Jun 30, 2005 5:52 am

Triifon, Red1,

Its a beautifully worded and formatted document. Well done.

I will apply the works when I get the opportunity , and it will be soon.

Thanks

Neil
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby red1 » Thu Jun 30, 2005 4:32 pm

Trifon, i was using previous version to yours, but i think more or less the same screenshots and concept cos I do not show source. I asked the users to refer to Compilo to get your latest source. I read your howto, it seems to do all in one place including ILF which i will write as Part II. I will amend the Part I later to put in your new build.xml. Also the Druid still doesn't generate ViewTest.xml and we have to do it manually. Anyway pls commit your files to Compilo so that i can give the download instructions.

Btw, does your new version handle the Role>Window activation and Tab-Order Sequence markings? Otherwise the user has to do them manually for new windows as i did for this 252d.

Neil, i just beautify the document further, so pls collect from the same spot again or wait for the amendment as per Trifon's latest build hopefully i can do that tonight.
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Postby trifon » Thu Jun 30, 2005 5:53 pm

red1 wrote:Btw, does your new version handle the Role>Window activation and Tab-Order Sequence markings?


This works in new versoin. If you look at sources you will see that for each new Window, it inserts records into AD_Window_Access table, there was and second fix in this direction, but i do not rememeber what exactly was the case.

I will submit my version of XML2AD in compilo project, at the moment i do not hava write right for CVs server, so i will post .zip file in Patches section.

Link to patch is:
https://sourceforge.net/tracker/index.p ... tid=657830

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

howto

Postby der_bonner » Thu Jun 30, 2005 8:13 pm

Hi Team,

you're really doing a great job ! ! !

But for me something like a little howto would be great.. just a few steps how to get from your zip file to the first created table / window

Mat

btw, is it also possible to use xml2ad only to create tables / cols without having the window?
der_bonner
 
Posts: 27
Joined: Thu Dec 16, 2004 12:41 am

Re: howto

Postby trifon » Thu Jun 30, 2005 8:17 pm

der_bonner wrote:Hi Team,

you're really doing a great job ! ! !

But for me something like a little howto would be great.. just a few steps how to get from your zip file to the first created table / window

Mat

btw, is it also possible to use xml2ad only to create tables / cols without having the window?


Hi Mathias,
thaks for the kind words.

Yes, we will post and how to, but just need some time.

Yes, you can create only Tables and columns.
just use "build model".

How to use it:
0 ) Copy "patch" direcotry to Compiere!
1 ) Copy build.properties.sample --> build.properties and set proper values!
2 ) Start "build createDB"; This will create all new tables.
3 ) Start "build alterDB"; This will add new columns to existing tables
4 ) Start "build model"; this wis well know task that will insert tables and column definitions into AD.
5 ) Start "build view"; this will create Windows and fields.
6 ) Start "build data"; This will insert definitions of ILF into AD_ImpFormat and AD_ImportFormat_Row tables (for example).

Regards,
Trifon
Trifon Trifonov
trifon
Senior
 
Posts: 324
Joined: Thu Dec 23, 2004 11:20 pm
Location: Bulgaria, Sofia

Postby neilg » Fri Jul 01, 2005 1:39 pm

I tested it out and it worked after making some changes, incl for 2.5.1g and also to work with the way our project is structured.

It looks very promising, however there are a few reasons why I can't use it in production yet.

I have quite a bit of feedback/suggestions/wishes, is it ok if I post them? If so where is the best place?

Regards Neil
neilg
Regular
 
Posts: 141
Joined: Thu Jun 16, 2005 1:58 pm

Postby red1 » Fri Jul 01, 2005 6:20 pm

ah.. compilo!.. go to compilo! we need u there! :lol:

thanks Neil... u re really burning the track here ;)
red1
Site Admin
 
Posts: 2760
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia


Return to Contributor's Corner

Who is online

Users browsing this forum: No registered users and 2 guests