Jump to content


Photo

SQL Schema

sql database

  • Please log in to reply
4 replies to this topic

#1 QwexyZ

QwexyZ

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 19 June 2012 - 05:51 AM

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.

#2 Fiery

Fiery

    AIDA64 Developer

  • Administrators
  • 4064 posts
  • LocationBudapest, Hungary

Posted 19 June 2012 - 10:08 AM

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

#3 QwexyZ

QwexyZ

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 19 June 2012 - 01:39 PM

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.

#4 Fiery

Fiery

    AIDA64 Developer

  • Administrators
  • 4064 posts
  • LocationBudapest, Hungary

Posted 19 June 2012 - 03:54 PM

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.

#5 QwexyZ

QwexyZ

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 20 June 2012 - 06:15 AM

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.





Also tagged with one or more of these keywords: sql, database

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users