Creating SQL DB - what is needed?

[AntSal60]

Greetings:

Need to create a DB to store definitions and have several questions:

1. the Database is going to be created by a DBA on a remote SQL server; is there a group of SQL statements that could be used to directly create the DB without using the ASG-RD program ?

2. If the ASG-RD program must be used to create the DB on a remote SQL server, which one of the ASG-RD programs can be used  ? a) the plain ASG-RD 2020 without the SQL code, b) The ASG-RD with the SQL code, or c) either of the 2.

3. Can I create multiple instances of the DB on the same server using different "user" or "schema" names? 

4. Do you have any additional documentation on the DB subject in addition to what is on the help DB ?

Many thanks.

Antonio S.

[DevOma]

1. The creation of an empty database is just "CREATE <database name> :-) Can be done by the program or by any other user - in ASGRD you can choose if you want to create a new database or use a empty database - next steps like create tables and stored procedures is done by the program

2. The SQL-Expression-Edition include the SQL-Express installer - so you don't need that if you have a running MS SQL Server

3. Sure you can create and connect to different databases on one server

4. I think all needed information can be found in the documentation - just use the Database Wizard to create the necessary schema - needed permissions are described in the online help