Getting Started with SmallSQL DBMS

1.) From an existing Database

You can convert an existing Database with JDbConverter. This is an open source tool to convert a database from one DBMS to another DBMS via JDBC. You can download it and convert your existing JDBC database.

2. Create a database with a GUI tool

We does not have such tool but we recommended one of the follow:

• JDBC Navigator. This is a free graphical Java tool. After you have download it
  • Select the menu "Open JDBC Data Source"
    Name: Small SQL Database
    Driver Class: smallsql.database.SSDriver
    URL: jdbc:smallsql
    Save and Connect
  • Open the menu "Connection | SQL Window"
  • Enter "CREATE DATABASE db1" and execute it with ENTER
  • Close the Connection
  • Select the menu "Open JDBC Data Source" and change the URL to
    jdbc:smallsql:db1
    Save and Connect
    
• SQuirreL SQL Client. This is an open source graphical Java tool. After you have download and install it
  • Create a new JDBC Driver
    Name: Small SQL Database
    Example URL: jdbc:smallsql:<db name>
  • Create a new Alias
    Name: Small SQL db1
    JDBC Driver: Small SQL
    URL: jdbc:smallsql
    Auto Logon: Yes
  • Connect to the alias "Small SQL db1"
  • Change to the tab "SQL"
  • Enter "CREATE DATABASE db1" and execute it
  • Close the window
  • Change the alias
    JDBC URL: jdbc:smallsql:db1
  • Connect to the alias "Small SQL db1"