Creating SQL Server encyclopedias and catalogs through SQL scripts
System Architect provides a set of SQL scripts to help you create SQL Server encyclopedias. These are provided in addition to the standard encyclopedia creation methods found in the Open Encyclopedia dialogs. They are intended to be used by persons with the rights and the expertise to run SQL scripts on SQL Server databases. It is suggested that the Database Administrator review and ensure that the scripts conform to enterprise standards before they are executed.
The scripts listed below are installed to the SQL Server subdirectory of the root System Architect directory, usually:
C:\Program Files\UNICOM Systems\System Architect Suite\System Architect\SQL Server
sqlTables.sql
Creates all tables and indexes.
sqlInserts.sql
Inserts required rows in the saproperties table.
sqlProcs.sql
Creates all stored procedures.
sqlCatalogCreate.sql
Creates a SQL Server catalog. Before executing the script, you must replace the ‘UserName’ value with the user name of a known administrator. After executing the script, you must open the catalog using Catalog Manager and select the Tools> Restore Default Items option.
sqlCatalogGrant.sql
Grants required user permission to an Oracle catalog.
To create a SQL Server encyclopedia using scripts
1 Create a new SQL Server database.
2 Using SQL Server Query Analyzer, run the above scripts (in that order) in the newly created databases.