DB Shell

DB Shell is toolkit used for performing various database operations, such as importing and exporting data, exporting database structure as documentation, or generating SQL scripts. It uses XAML syntax for defining operations very effectively.
Db Shell is in early development state, but it is already usable. All features all covered with unit test, which guarantees high quality. Lot of code of Db Shell is given from database tool called DatAdmin, so altough it is young project, it is based on well tested and many years developed code.

How it looks

XAML syntax is subset of XML. The following basic example shows, how to export table content to CSV using DB shell.

<?xml version="1.0" encoding="utf-8" ?>
<CopyTable
    xmlns="http://schemas.dbshell.com/core"
    Connection="sqlserver://MultipleActiveResultSets=True;Data Source=localhost\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=Chinook"
    Source="{Table Album}"
    Target="{File Album.csv}"
    >
</CopyTable>

Basic features

  • Supported engines
    • Microsoft SQL
    • MySQL, SQLite - planned in near future
  • Export - CSV, HTML (using razor), CDL (dbshell proprietary binary table data format)
  • Import - CSV
  • Data sources - tables, queries
  • Variable replacing - similar principle as in NANT
  • ForEach cycle
  • You can saemlessly combine anything, what makes jist a little sense

Last edited Nov 19, 2012 at 6:56 PM by dbshell, version 19