All columns from basic XML file are nvarchar(MAX)

[acnicholls]

This isn't really a bug, since the XML file can be really complex and list data types, but basic XML files will have scripts created that create all columns as nvarchar(MAX).

If the user declares the datatype in the XML file, it will be used to create columns of the same type in the resulting script.

Could write a function that tries to guess the columns datatype, but that would be tedious and very error prone, as well as require MUCH testing.