Skip to main content

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 New DB Query

This has now created the new database in the server you connected to. You can view the query and result in the output window of Data Sync.

New Database Created

Other SQL Statements​

In addition to CREATE and SELECT statements, you can use a wide range of other SQL statements in the SQL Query Tool. For example, you can use UPDATE, DELETE, and CASE statements to edit and manipulate your data. This will enable you to perform complex operations on your data, such as updating multiple records at once or deleting specific rows based on a certain condition.

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

You can make use of the SQL scripting tool in the Schema Map window to help you create new tables and columns.