microsoft/mssql-scripter

UserDefinedTypes are not being scripted

bbct opened this issue · 1 comments

bbct commented

Great tool! it scripted the entire schema, except for my User Defined Types. I tried the following, but got zero objects exported each time:

--include-types UDFs
--include-types UserDefinedTypes
--include-types UserDefinedDataTypes

Is there some way to include UDFs in the output?

bbct commented

Ok, I figured this out myself.
The proper --include-types is UserDefinedDataType (at least that's what I was trying to export).
I had also include --target-server-version AzureDW
which, once I got the include_types correct, threw an exception that AzureDW doesn't support UserDefinedDataType definitions.

I removed the --target-server-version AzureDW parameter, and all objects including the UserDefinedDataType objects were exported just fine. The --target-server-version parameter I meant to use is AzureDB, and that does support UserDefinedDataType objects.