4 replies to this topic

[QwexyZ]

Please, help.
How to create a database for aida64 using .sql files stored in the SQL schema folder?
We have a SQL server 2008 R2 installed.

Thank you in advance.

[Fiery]

You can initialize the database using SQL Server Management Studio. You need to use the SQL schema file DB - SQL Server.sql that you can find in the AIDA64 installation ZIP package or its installation folder.


Regards,
Fiery

[QwexyZ]

The file opens with SQL management studio but what should be done next? It must be just executed? Does it require a preconfigured database?
Please, give some directions.

[Fiery]

The schema will initialize the database, so all you need is create an empty database (name it e.g. aida64), and then run the script. You may need to remove the first two dash characters to make sure the script would use the right database.

Please note that the SQL module of AIDA64 is designed for experienced SQL users -- that's why it's not documented too much If you're unsure about how to configure a SQL Server, then you may want to switch to creating CSV reports and use the Audit Manager and Change Manager based on CSV reports. It may be an easier way to collect and sort out reports.

[QwexyZ]

Thank you so much! That's exactly what I needed i.e. these two dashes at the beginning were the point I was stuck at.
My SQL database now runs OK.