The Union Platform (tm) - transition to final version -

transition to final version

Added by Kenneth Chang 390 days ago

Hi, i am in a process of testing union beta2 and was wondering if the accounts and presistent data created during the beta by the users can be transferred to final version? and how difficult will it be?

Replies

RE: transition to final version - Added by derek clayton 389 days ago

Hi Kenneth,

There was one data structure change to the length of the VALUE column for attributes (see http://factory.user1.net/issues/show/468). This would be an increase in the size of the field for Derby, the default database that ships with Union. If you really want to move over your data then when you are ready to upgrade to 1.0.0:

1) Stop the Beta 2 Union Server.
2) Make a copy of the unionDB directory.
3) Do a clean install of Union 1.0.0.
4) Copy the unionDB directory back in to the root of your clean install.
5) Use a Derby client to alter the VALUE column size to 768 in the SERVER_ATTRIBUTE, ROOM_ATTRIBUTE, ACCOUNT_ATTRIBUTE tables. I'd recommend SQuirreL SQL client (http://www.squirrelsql.org/). See http://db.apache.org/derby/manuals/reference/sqlj26.html#HDRSII-SQLJ-81005 under the section "Modifying Columns". There's a chance you can skip this step and get away with it since the database already exists and the length field is used for generating a DDL. However, you will be constrained to the 256 length limit that was used in Beta 2.
6) Start the 1.0.0 Union Server.

Hope that helps,

Derek