QwexyZ

SQL Schema

5 posts in this topic

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now