I want to convert the database definition of an existing SQL database into an XML schema, so I can use the schema with some model-driven development tools to create a new distributed application that ...

You're not providing quite enough information, what mechanism (not just ODBC) are you using to transport the data? A DTS/SSIS package? A piece of custom software?