Best way to migrate data dictionary from development to prod

[neilg]

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]

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.

[red1]

The steps described by Neilis exactly what Druid and XML2AD accomplishes. I will rush my tutorial and publish here and at compilo.

[neilg]

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

Look forward to it.

[red1]

Here it is Neil:

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

Its the first easy draft. I will upload it to compilo later.

[trifon]

Is it the latest one, that i have developed?

Regards,
Trifon

[neilg]

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

[red1]

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.

[trifon]

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

[der_bonner]

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?

[trifon]

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

[neilg]

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

[red1]

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

thanks Neil... u re really burning the track here