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 ...

This is a user generated content for MyStory, a YourStory initiative to enable its community to contribute and have their voices heard. The views and writings here ...

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?