xmlToSql

Reference Code backup Executable files

Convert XML dump into a fairly normalized relational databasein the form of a directory full of tab-separated files and tablecreation SQL. You'll need to run autoDtd on the XML file first toget the dtd and stats files.

Category

Generic

Usage

xmlToSql in.xml in.dtd in.stats outDir

Manual

This tool is part of UCSC Genome Browser's utilities.

options:
-prefix=name - A name to prefix all tables with
-textField=name - Name to use for text field (default 'text')
-maxPromoteSize=N - Maximum size (default 32) for a element that
just defines a string to be promoted to a field
in parent table

Share your experience or ask a question