Create a new Speed database/table in SQL

To create a new speed database with Microsof SQL Server, select Applications > AVLS > Load AVLS Data.

In the window that opens, select Create new... and choose Microsoft SQL Server.

  1. Select the server name from the drop-down. Try Refresh if you do not see your server in the list.
  2. Choose either Windows Authentication or SQL Authentication.
  3. If in doubt, speak to your Database Administrator.
  4. Type in the Security credentials (Login and Password)
  5. In SQL Server, when you create a new ‘Speed database’ you have two ‘options’:
    • Create a new speed table in an existing SQL Server database / catalog;
    • Create a new speed table AND create a new SQL Server database / catalog
  6. The last drop-down (‘New or existing database’) contains a list of databases. You can either:
  7. Select an existing database in which a new Speed table will be created, or
  8. Enter the name of a new database to be created and in which a Speed table will be subsequently created.
  9. Click Next.

The drop-down box labelled ‘New or existing schema’ will contain a list of schema the user can access. You can either:

Select an existing schema or enter the name of a new schema to be created.

Enter a name for the table and click Next to create it.

Note: Next will be disabled if the name you have entered already exists. Type another name.

If you are using an existing speed database / table

On connecting to the SQL Server database, the next page displays a grid containing all the tables that have the columns required of a Speed table in all the schemas in the database to which the user has access.