2

How to create Database in Sql Server using xml schema and xml data file.

I tried different things I cant solve the problem.

I am using these files

XML SCHEMA: http://www.drugbank.ca/docs/drugbank.xsd

XML DATA FILE: http://www.drugbank.ca/system/downloads/current/drugbank.xml.zip

I tried How to build a database from an XSD schema and import XML data but it gives me some errors. please help me to solve this :)

Community
  • 1
  • 1
Ahmad Abbasi
  • 1,776
  • 6
  • 29
  • 43
  • Nobody can help you. You haven't told us what's wrong! – John Saunders Feb 19 '14 at 18:25
  • 1
    @JohnSaunders when i try this one http://stackoverflow.com/questions/2628327/how-to-build-a-database-from-an-xsd-schema-and-import-xml-data. it just give me this error. "Package Execution completed with error..... " – Ahmad Abbasi Feb 19 '14 at 18:30
  • possible duplicate of [Using XML and XSD to create a populated database](http://stackoverflow.com/questions/11531266/using-xml-and-xsd-to-create-a-populated-database) – Paul Sweatte Jun 19 '14 at 20:16

1 Answers1

-1

I used to create a array from the xml file and then insert in to the database.

rahul singh
  • 451
  • 1
  • 3
  • 17