snippetsqlMinor
Generate DDL Statement from XSD file
Viewed 0 times
filestatementxsdddlgeneratefrom
Problem
I have a database schema exported into XML format.
My goal is to create a DDL statement from the XSD files that I can use to import the data into a different platform without manually having to parse it myself.
There is very little information on XSD files in general and it seems that only Oracle have any support at all for them.
My goal is to create a DDL statement from the XSD files that I can use to import the data into a different platform without manually having to parse it myself.
There is very little information on XSD files in general and it seems that only Oracle have any support at all for them.
Solution
Sometimes you overlook the basic tools; Microsoft Access Imported the file straight up.
Opened a new Blank Database in Access
External Data -> XML File -> Select the file.
Then I pointed my Access database to an SQL Server backend and just used SSMS to generate the DDL Statement to make the schema portable.
Thanks for the help!
Opened a new Blank Database in Access
External Data -> XML File -> Select the file.
Then I pointed my Access database to an SQL Server backend and just used SSMS to generate the DDL Statement to make the schema portable.
Thanks for the help!
Context
StackExchange Database Administrators Q#184904, answer score: 2
Revisions (0)
No revisions yet.