I am new to TDM so forgive me if this is a rookie question. I searched yet didn’t find any answers to this issue.
I have reverse engineered our ‘very’ old database and am now modeling it for our new system. There are over 200 tables. I have changed all my data types to our new proper standardization (CHAR to VARCHAR for example) and have reached an issue. We are not going to allow NULL values for most of our fields, so for a VARCHAR I have selected NOT NULL and want to set the default value to ‘’. I can do this by clicking on each field in the entity properties window and setting the value, but with all of the columns and tables I have, this will take quite some time.
Is there a quick way to set the default values of many columns in TDM or should I stick with just text editing the raw SQL and reimporting the model back in? I thinking there has to be some way I have not found to bulk change the data types in an existing model.
Thanks in advance.