Altering Entity Field Sizes

[Justin Dagostino]

I know OFBiz has the ability to manage the DB schema, but doesn't appear to
alter column sizes. (or drop columns that have been removed from your
entity definition for that matter).

Is there a way to alter column sizes 'dynamically'?  I came across the
"repair column size" feature in Webtools, but that doesn't seem to do
anything either.

Are people managing their Production DBs outside of OFBiz?

Please comment.

Thank you.


---
*Justin Dagostino*
Director Of Engineering
TheCools.com

[Adrian Crum-3]

I believe the ability to modify the schema is dependent upon the JDBC  
driver. In some cases, schema modification must be done with DB  
utilities.

-Adrian


Quoting Justin Dagostino <[hidden email]>:

> I know OFBiz has the ability to manage the DB schema, but doesn't appear to
> alter column sizes. (or drop columns that have been removed from your
> entity definition for that matter).
>
> Is there a way to alter column sizes 'dynamically'?  I came across the
> "repair column size" feature in Webtools, but that doesn't seem to do
> anything either.
>
> Are people managing their Production DBs outside of OFBiz?
>
> Please comment.
>
> Thank you.
>
>
> ---
> *Justin Dagostino*
> Director Of Engineering
> TheCools.com
>

[Justin Dagostino]

I see.  Thanks, Adrian.

Hope you're doing well.

---
*Justin Dagostino*
Director Of Engineering
TheCools.com


On Tue, Apr 1, 2014 at 4:32 AM, <[hidden email]> wrote:

> I believe the ability to modify the schema is dependent upon the JDBC
> driver. In some cases, schema modification must be done with DB utilities.
>
> -Adrian
>
>
> Quoting Justin Dagostino <[hidden email]>:
>
>  I know OFBiz has the ability to manage the DB schema, but doesn't appear
>> to
>> alter column sizes. (or drop columns that have been removed from your
>> entity definition for that matter).
>>
>> Is there a way to alter column sizes 'dynamically'?  I came across the
>> "repair column size" feature in Webtools, but that doesn't seem to do
>> anything either.
>>
>> Are people managing their Production DBs outside of OFBiz?
>>
>> Please comment.
>>
>> Thank you.
>>
>>
>> ---
>> *Justin Dagostino*
>> Director Of Engineering
>> TheCools.com
>>
>>
>
>
>