Generating a table creation script
If necessary, you can create a generic SQL script that will, when executed, create the tables required by Asta Powerproject in a new direct connection (ADO) data source. Table generation scripts are only used during the creation of direct connection data sources.
The tables that are required by Asta Powerproject are normally created automatically when you create a direct connection data source, so you do not usually need to generate and execute a table creation script manually. You only need to do this if the table creation process fails - which it may do if you create a data source when you have insufficient permissions, for example.
To generate a table creation script:
- Select a direct connection data source, then select the Generate Table Creation Script command from the Datasource menu. The Save As dialog appears.
- Select the folder in which to create the script file and enter the file name of the table creation script. Give the script a file extension of .SQL.
- Click Save to save the table creation script.
If necessary, you can edit the script file in Wordpad to include details of tablespace sizes. Consult a basic Microsoft SQL Server® reference book for details of how to do this. If you do not edit the file, verify with the System Administrator that the default table sizes are suitably flexible, ie not limited to anything below 20Mb.
You can now execute the table creation script to create the tables required by Asta Powerproject in the direct connection data source:
If you are creating a Microsoft SQL Server data source, execute the script using the Query Manager within the Enterprise Manager.