If your organization is setting up a new MS SQL or PostgreSQL (available with releases R53 and later) database for a SystemWeaver server application to connect to, you will need to create the internal database that the SystemWeaver server uses. This article describes how to do this. 


Note: If you are using a SQLite database with your SystemWeaver server, this step is not necessary. 


  1. Open the swDatabaseManager.exe which you'll find in the Server directory. 
  2. Chose MS SQL Server or PostgreSQL as the Type.
  3. Enter the database information:  

    R53 and later releases: Enter the information manually or use the Load config button to load it from an existing swServer.ini file that contains the database information in the DNS= entry. See DSN in Installing a New SystemWeaver Server for the format to use by database type.
    R52 and earlier releases:  Enter the information manually.  

  4. In the User and Password fields, you must enter the credentials of an account that has sufficient db permissions to the database in order to create the tables. For MS SQL Server only: If the Windows domain account you are using has sufficient permissions to the database, you can leave the fields blank.

  5. To create the tables: 

    R53 and later releases: Click Initialize.
    R52 and earlier releases:  Click Create empty v1.XX. For installations using the latest SystemWeaver version, select the highest database version #. If you are unsure which version to use, see Which Database Version Are We Running?, and Software Releases with Client API and Database Versions, or contact support@systemweaver.com.

What's Next? 

You can now test connecting the SystemWeaver server to the database. See Testing a SystemWeaver Installation for instructions on how to use the swTestServer utility to run the server.