DiskSavvy Logo

Exporting Reports to an SQL Database

DiskSorter Pro and DiskSorter Server provide the ability to export disk space analysis results to an SQL database via the ODBC database interface. In order to be able to export disk space analysis results to an SQL database, the user needs to configure the ODBC database interface on the main options dialog.

DiskSavvy SQL Database Configuration Options

In order to configure the ODBC interface, open the main options dialog, select the 'Database' tab, enable the ODBC database interface, enter the ODBC data source name, the ODBC user name and password to use to connect to the SQL database and then press the 'Verify' button to check the specified ODBC interface.

DiskSavvy Export Results to SQL Database

Once finished configuring the ODBC database interface, select one or more directories and/or files, press the right mouse button, select the 'Export To SQL Database' menu item and enter the name of the SQL database table to export disk space analysis results to. DiskSavvy will connect to the specified SQL database and export the selected disk space analysis results to the specified SQL database table.

Microsoft Excel Import From SQL Database

In order to import disk space analysis results from an SQL database to Microsoft Excel, select the menu 'Data - Import External Data - New Database Query' menu item, select the ODBC data source to import the data from, select the SQL database table name that was specified during the export operation, select SQL database table columns to be imported, optionally select the data sorting mode and press the 'Finish' button.

DiskSavvy Disk Space Analysis Results In Excel

For each disk space analysis result, DiskSavvy exports to the SQL database the following columns of data: a unique result ID, the type of the result (DIR or FILE), the creation date, the last modification date, the last access date, the total number of files in a directory, the total size of all files in the directory, the percentage of the disk space used by all files in the directory, the user name of the file or directory and the full name.

DiskSavvy News

30-Oct-2025

DiskSavvy v17.4 adds support for new file types to the built-in file classification plug-ins allowing one to categorize and filter disk space analysis results by the file type. In addition, the new product version improves the performance of the disk space analysis operations on multi-core and multi-CPU systems and fixes a number of bugs.

30-Sep-2025

DiskSavvy v17.3 adds the ability to export the disk space analysis results file categories to the JSON report format allowing one to generate various types of bars charts and pie charts using AI data analysis platforms. In addition, the new version improves the main DiskSavvy GUI application, improves the network search dialog and fixes a number of bugs.

More News