XSD schema to SQL server

[Guest]

What is an easy way to save an XSD schema into SQL server database? I have a
dataset which I have access to both its data and the schema. I read that
from a CSV file. There are more than 50 fields. I would like to find an
easy way to create and modify the tables in the SQL database while having
access the XSD. I can import the XSD in my project files.

I have generated XSDs from existing SQL Server tables into my VB .NET
project in the past through the wizard. Does the wizard work the other way??

Thanks for your help.

 

[Cor Ligthert]

Baskin,

Make your Create Datatable SQL statements and execute those with
command.executenonquery

And as I write this forever in my opinion it should be possible to make it
generic. And than I ask when you have done it, please contribute that to
this newsgroup.

I hope this helps something anyway?


Cor

 

[Guest]

Thanks, Cor.

I think I understood what you are suggesting. What I am thinking of doing
is for each column in the data set, build the "CREATE TABLE string" and
execute against the database. Is this correct?

Sorry it took awhile to get back to you due to holidays and such. I will
start coding this and post my solution here as generic as possible.

Thanks again for your reply and suggestion.

Sincerely,

- Baskin Tapkan
Oakdale, MN USA