Creating a database in Microsoft SQL Server or MSDE |
Manual -> Industrial Performance Analyzer (IPA) -> Connection to the database -> Creating a database in Microsoft SQL Server or MSDE |
Show all Hide all |
You also can create a database with the command interpreter, if no user interface for your SQL server is available.
Start a new instance of the command prompt (cmd.exe).
In the command interpreter the tool osql.exe can be started with the following instruction.
osql.exe -E -S computer name / instance name
The instructions for creating a database:
1> CREATE DATABASE database name
2> GO
Database name |
any name for the database. e.g.: IPA |
With 'exit' the program osql.exe is closed.
The table in the database is automatically created on the first start of the Runtime by zenon.