DbShell

OpenSource database toolkit using XAML for describing jobs

User Tools

Site Tools


Sidebar

DbShell

DbMouse

DbMouse is database GUI, which has support for DbShell. It could be used as DbShell console.

start

Table of Contents

Home

DB Shell is free and opensource toolkit for automation of database operations. It uses XAML subset of XML language, so there are many editors allowing comfortably edit DB shell code. It is licensed under LGPL license.

Simple example

This very simple example exports data of table Album into CSV file.

<?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}"
/>

The explanation can be found in introduction to DbShell.
More examples are available in Samples directory.

Graphics tools

If you prefer graphics tools over command line, there are some Windows applications working with DbShell:

These tools have already connection to database, so you can omit it in jon definition, so previous example will look like following:

<?xml version="1.0" encoding="utf-8" ?>
<CopyTable
  xmlns="http://schemas.dbshell.com/core"
  Source="{Table Album}"
  Target="{File album.csv}"
/>
start.txt · Last modified: 2015/10/26 14:23 by admin