User Guide
Introduction
Data Sources
Schema Map
Data Compare
Lookups
Calculated Columns
Dynamic Columns
Project Automation
Project Properties
Ouvvi User Settings
DSCache
Encryption
SQL Query Tool
Analysis Grouping
Incremental Sync Mode
Proxy Server
Schedule
Run Tool

Create a New Database

To create a new database using the SQL Query Tool type in a SQL statement like below and then click Run Query.

CREATE DATABASE NewDatabaseName

Run Query

This has now created the new database in the server you connected to.

Database Created

Other SQL Statements

You can make use of any SQl statements not just CREATE and SELECT. For example, you can make use of UPDATE, DELETE and CASE Statements to edit and manipulate your data.

For more examples of SQL Statements and how these can be used please visit W3Schools.