Converting SMO Data Types to SqlDataTypes

Question

I am using SMO to compare one database against another.

This compare utility is NOT using drop and replace type of logic, It's using ALTER statements.

So, when I compare one column against another and they are not equal, I need to generate an Alter statement.

In order to generate that Alter statement, I need to convert the Column.DataType to something in the realm of SQL.

I've been looking but haven't found anything that will convert a DataType into an SQL DataType string. Can someone help me out here?

You mean you need something like this? msdn.microsoft.com/en-us/library/cc716729.aspx — Comfortably Numb, Commented Aug 2, 2013 at 19:29

ilker Yesilkaya · Accepted Answer · 2019-03-17 13:31:39Z

0

DataType p = new DataType() ;
p.SqlDataType = SqlDataType.NVarChar;
p.MaximumLength = 200 ;

answered Mar 17, 2019 at 13:31

ilker Yesilkaya

111 bronze badge

1 Answer 1