Re: XSD schema to SQL server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: BaskinT (BaskinT_at_discussions.microsoft.com)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 09:14:41 -0800

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" <BaskinT@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
>
>
>

Relevant Pages

  • RE: Import Data from Csv AND set relationships
    ... Well, I am not Scottish, but I do drink a lot of Scotch. ... I was not suggesting using the import to create a table. ... these columns contain the same data set. ... I have a database that imports details of employees on a daily basis. ...
    (microsoft.public.access.externaldata)
  • Re: Unique in-depth problem
    ... The back end is SQL, for the sake of sanity I broke up the dates into ... What options do I have in Perl for handling dates of this nature ... Precompute all the dates and put them in a database (file, SQL server, ... a huge data set, yet manage to retrieve and show only the interesting ...
    (comp.lang.perl.misc)
  • Re: Excel validation.
    ... The upload function will run a validation routine and I am ... would process each row in the spread sheet and call a SQL procedure to ... return a data set, the data set would hold one record if the GL# was ... I also make the use a parameter in the SQL and link it to a cell in ...
    (comp.sys.ibm.as400.misc)
  • Re: Help - Displaying the max vaule from SAS data set
    ... I have SAS data set which contains numeric variables and now I want to ... easy and nice solution is using SQL. ... If it's tricky to do using data steps, try SQL; if it's tricky to do using SQL, try data steps. ...
    (sci.stat.math)
  • Re: Way too many Stored Procedure Parameters
    ... Start by creating a typed data set, ... Run SQL Server profiler on the database in SQL Server (filter by your ... Once you have your stored procedure, you can just drag it into VS.NET ...
    (microsoft.public.dotnet.languages.csharp)