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



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 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.


© 2020 HVR

Test drive Contact us