Test environment setup

Roughly, the steps for setting up a test environment are:

1. Download and install a trial version of ASE
2. Set up a test database
3. Enter connection details into DatabaseLoginDetails.json

---

The following script should suffice to set up a test database

use master
if exists (select 1 from master..sysdatabases where name = 'your_test_db')
begin
  drop database your_test_db
end

create database your_test_db
  on default = '512M'

go

use your_test_db
exec sp_configure 'number of user connections', 100
go

We've found that tests can hang if:

• The database's number of user connections setting is too small
• The database's allocated size is too small
  • ASE might emit a message like the following: X task(s) are sleeping waiting for space to become available in the segment 'logsegment' for database 'your_test_db'