RoundhousE does not update its own Tables

Question

RoundhousE does not update its own Tables

BiggerNoise opened this issue 13 years ago · 6 comments

Bit ironic really :)

We started with an old version of RH on our servers. Now when we get errors, we get the barf that RH cannot insert into the errors table (message is truncated).

Looks like Message field in the ScriptRunErrors table was changed from nvarchar(255) to ntext a while back, but RH doesn't version its own tables so we get the log barf instead of the real error message.

I can take a look at this, unfortunately, it may lead to a state of infinite recursion.

Answer 1 · 2011-09-10T04:27:05.000Z

Unfortunately it's a limitation of nh that it doesn't change existing columns very well.

Answer 2 · 2011-09-10T09:14:59.000Z

What we can do is add something to explicitly make the change to the table if the size is not correct.

Answer 3 · 2011-09-10T16:33:22.000Z

Cool, I will get around to taking a look at this.

Answer 4 · 2011-09-10T16:34:03.000Z

sorry on the close, finger fumble

Answer 5 · 2011-09-10T20:13:32.000Z

They shouldn't be so close together...lol

Answer 6 · 2011-09-22T11:00:12.000Z

Originally the thought was to go with NHibernate and Fluent NHibernate because they would provide the most surface into internal upgrades. We may want to explore options here at some point, but we can add a database specific upgrade task for now to handle when we do things that nh doesn't pick up.