Just checking to see if there is an easier way to do this:
I have a customer who needs a field size increase of a string field in one of my custom Dexterity applications. The field is only used in a couple of SQL tables. In the past, I would perform the following steps: (1) Create a temporary duplicate table of the production table to be modified; (2) Copy the data from the production table to the temporary duplicate table; (3) Expand the field size in the production table; (4) Run SQL maintenance to initialize the production table; (5) Copy the data from the temporary duplicate table back to the newly modified production table.
Is there an easier way? Am I overlooking some SQL utility that does this?
Thanks
*This post is locked for comments
I have the same question (0)
