Bulk field operations

Sometimes you need to change the fields from a complete table or a set of tables from a certain type to another: e.g. set all varchar fields to varchar(max).

It would be handy to be able to select a number of tables and perform such a bulk action. Examples: change all varchar(50) to nvarchar(50). Change all ints to bigints, change all datetime to datetime2 etc...

Allthough synchronize data source does part of the trick if the source gets modified, I would rather set all my varchars to a certain length to be safe. Especially in  arapid changing source this saves the trouble of deploying often just to keep the thing running.

1 comment

Please sign in to leave a comment.