Define new database
This chapter describes the steps required to create a new virtual database.
In order to add a database, please go to the DATABASE section accessible directly from the sidebar, then on the top right-hand corner click the ADD DATABASE button.
Source provider for existing connection
This section is shown as the default one. It displays options for already defined connection. When you want to define the new connection here then change Select connection option to New connection. Such action changes the wizard options.
| Parameter | Required | Default value | Description |
|---|---|---|---|
| Database name | Yes | New database name. It is system-wide unique. | |
| Select connection | Yes | Existing connection | Specifies if we want to reuse existing connection or create a new connection within this wizard. The available options are Existing connection or New connection. |
| Existing connections | Yes | The list of the connections defined before in the Connections. |
Available actions:
- CANCEL - it abandons the changes and goes back to the databases list.
- NEXT - it goes to the next screen.
- CREATE - it creates the virtual database.
Source provider for new connection
This section should be used when you did not specified the connection yet. Alternatively you can go directly under CONNECTIONS section.
| Parameter | Required | Default value | Description |
|---|---|---|---|
| Database name | Yes | New database name. | |
| Select connection | Yes | Existing connection | Specifies if we want to reuse existing connection or create a new connection within this wizard. The available options are Existing connection or New connection. |
| Connection name | Yes | The connection name. | |
| Existing connections | Yes | The list of the connections defined before in the Connections. |
Available actions:
- CANCEL - it abandons the changes and goes back to the databases list.
- NEXT - it goes to the next screen.
Provider parameters
This section is visible only when New connection for Select connection with the Source Provider section has been chosen. The configuration parameters were described in the add connection section.
Source database
This section appears only when the Source provider is based on SQL Server connection.
| Parameter | Required | Default value | Description |
|---|---|---|---|
| Initial catalog | Yes | Specifies the initial catalog name from available databases related to the database. |
When you select the Initial Catalog during connection creation then it will be selected by default (see adding the connection). In addition, the list of the databases that can be selected is limited to these that have the compatible collation. The screen has additional information *Databases with incompatible collation under Initial catalog drop-down.
Available actions:
- CANCEL - it abandons the changes and goes back to the databases list.
- NEXT - it goes to the next screen.
- CREATE - it creates the virtual database.
Import metadata
In this section, you can select objects from the database that will be imported once the database is created. It displays schemas, tables or views within schemas, columns and their types. You can define which objects and their columns are imported.
If you check Calculate row count statistics then calculating the row number for each selected object will be executed.
Available actions:
- CANCEL - it abandons the changes and goes back to the databases list.
- CREATE - it creates the virtual database and imports the selected objects.
