Howto migrate database to new codebase; 12.04 to 12.04.03 using built-in database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Howto migrate database to new codebase; 12.04 to 12.04.03 using built-in database

ofbiz.user
I have a test instance based on 12.04 and some own additions,
filled with some test data.

I am using the built-in DB engine.

How can I move my test data to a 12.04.03 based instance?

Should I

a) update my codebase, evtl. re-apply my code changes
   (how?, would the data stay intact?)

b) checkout a new codebase, re-apply my changes, move tha data?

Which are the files containing the data?

Are there export/import functions of ofbiz I could use to migrate
the data?


Kind regards,

ofbiz.user

Reply | Threaded
Open this post in threaded view
|

Re: Howto migrate database to new codebase; 12.04 to 12.04.03 using built-in database

Pierre Smits
Hi OFBiz User,

In webtools there are functions available to export your data set to a
given directory.

You can use that dataset to import in your new instance.

Regards

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Tue, Jun 17, 2014 at 1:34 PM, <[hidden email]> wrote:

> I have a test instance based on 12.04 and some own additions,
> filled with some test data.
>
> I am using the built-in DB engine.
>
> How can I move my test data to a 12.04.03 based instance?
>
> Should I
>
> a) update my codebase, evtl. re-apply my code changes
>    (how?, would the data stay intact?)
>
> b) checkout a new codebase, re-apply my changes, move tha data?
>
> Which are the files containing the data?
>
> Are there export/import functions of ofbiz I could use to migrate
> the data?
>
>
> Kind regards,
>
> ofbiz.user
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Howto migrate database to new codebase; 12.04 to 12.04.03 using built-in database

Anil Patel-3
In reply to this post by ofbiz.user
In theory,

You should not have to worry about the database. All you have to do is update code base. Build (compile) and start server.



Thanks and Regards
Anil Patel
COO
Hotwax Media Inc
http://www.hotwaxmedia.com/
ApacheCon US 2014 Silver Sponsor
http://na.apachecon.com/sponsor/our-sponsors
Sent from my iPad

> On Jun 17, 2014, at 7:35 AM, [hidden email] wrote:
>
> I have a test instance based on 12.04 and some own additions,
> filled with some test data.
>
> I am using the built-in DB engine.
>
> How can I move my test data to a 12.04.03 based instance?
>
> Should I
>
> a) update my codebase, evtl. re-apply my code changes
>   (how?, would the data stay intact?)
>
> b) checkout a new codebase, re-apply my changes, move tha data?
>
> Which are the files containing the data?
>
> Are there export/import functions of ofbiz I could use to migrate
> the data?
>
>
> Kind regards,
>
> ofbiz.user
>
Reply | Threaded
Open this post in threaded view
|

Re: Howto migrate database to new codebase; 12.04 to 12.04.03 using built-in database

taher
Hi

A few comments on the issue of database migration:

- First, although you can alter the entitymodel.xml files, sometimes you
have to tweak the database a bit in terms of field definitions. I am not
sure if it is intended behavior or a bug though
- Second, there is an entity import/export (using XML) tool under the
webtools component which is fantastic for migration purposes
- Finally, if your database migration is complex (ETL stuff or you need to
split for example, a field into two fields) then I would recommend using
liquibase or equivalent, it is an excellent tool to that end. You can apply
changes, revert changes, etc ...

My two cents!

Taher Alkhateeb


On Tue, Jun 17, 2014 at 3:08 PM, Anil K Patel <[hidden email]>
wrote:

> In theory,
>
> You should not have to worry about the database. All you have to do is
> update code base. Build (compile) and start server.
>
>
>
> Thanks and Regards
> Anil Patel
> COO
> Hotwax Media Inc
> http://www.hotwaxmedia.com/
> ApacheCon US 2014 Silver Sponsor
> http://na.apachecon.com/sponsor/our-sponsors
> Sent from my iPad
>
> > On Jun 17, 2014, at 7:35 AM, [hidden email] wrote:
> >
> > I have a test instance based on 12.04 and some own additions,
> > filled with some test data.
> >
> > I am using the built-in DB engine.
> >
> > How can I move my test data to a 12.04.03 based instance?
> >
> > Should I
> >
> > a) update my codebase, evtl. re-apply my code changes
> >   (how?, would the data stay intact?)
> >
> > b) checkout a new codebase, re-apply my changes, move tha data?
> >
> > Which are the files containing the data?
> >
> > Are there export/import functions of ofbiz I could use to migrate
> > the data?
> >
> >
> > Kind regards,
> >
> > ofbiz.user
> >
>