Altova XMLSpy 2024 Professional Edition

When an XML Schema is generated from an MS SQL Server database (DB), the MS SQL Server DB datatypes are converted to XML Schema datatypes as listed in the table below.

 

MS SQL Server Datatype

XML Schema Datatype

uniqueidentifier

xs:ID

char

xs:string

nchar

xs:string

varchar

xs:string

nvarchar

xs:string

text

xs:string

ntext

xs:string

sysname

xs:string

bit

xs:boolean

real

xs:float

float

xs:double

decimal

xs:decimal

money

xs:decimal

smallmoney

xs:decimal

datetime

xs:dateTime

smalldatetime

xs:dateTime

binary

xs:base64Binary

varbinary

xs:base64Binary

image

xs:base64Binary

integer

xs:integer

smallint

xs:short

bigint

xs:long

tinyint

xs:byte

 

© 2017-2023 Altova GmbH