Reply To: How to change datatypes of specific columns for all tables

#24504
Mark
Keymaster

Mohammed,

In HVR you can use the action ColumnProperties to modify the data types for columns. To do this for all columns with a specific data type you can use the action ColumnProperties with argument /DataTypeMatch. You can use this with number as the source and options for scale/precision. Please see https://www.hvr-software.com/docs/actions/columnproperties#ColumnProperties-Parameters for the details. Then pick the target data type you want and any scale/precision. Note that the DDL HVR generates must be able to run on the target – SQLDWH in your case.

Hope this helps.

Mark.

© 2020 HVR

Test drive Contact us