By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

XSD schema to SQL server

P: n/a
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.
--
Software/Database/Network Engineer, MCSE MCDBA
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

"BaskinT" <Ba*****@discussions.microsoft.com>
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.
--
Software/Database/Network Engineer, MCSE MCDBA

Nov 21 '05 #2

P: n/a
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

"Cor Ligthert" wrote:
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

"BaskinT" <Ba*****@discussions.microsoft.com>
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.
--
Software/Database/Network Engineer, MCSE MCDBA


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.