You can automate index management using the command line. This page provides a list of the switches you can use with the dbForge Index Manager command line.
indexmanager [/argfile:path] [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]
The first argument for datacompare is usually an operation switch that corresponds to the operation that you want to perform with the application.
Note
To run the Command Line in Windows 10:
From the Desktop Mode
- Move the mouse cursor to the exact lower left corner until the desktop shortcuts menu appears.
- Right-click to see the shortcut menu and than click Run.
From the Charms Bar
- Move your mouse to the upper right corner until the Charms Bar appears.
- Select Apps from the list and type ‘run’ in the search box.
- Click Run from the search results.
Use Windows + R Shortcut Keys
- In desktop mode, press the Windows + R keys, to show the Run command line.
- In the window that opens, type cmd and press Enter.
1. Specify the operation you want to perform and the required parameters and arguments (actions you want to run) in the Command Prompt, for example as follows:
"C:\Program Files\Devart\dbForge SQL Tools Professional\dbForge Index Manager for SQL Server\indexmanager.com" /analyzeindex /?
2. Press ENTER to run the process.
| Switch | Description and usage |
|---|---|
| /argfile | Specifies a path to the command line arguments file. Options specified via the command line have higher priority than the options given in the file. Usage: /argfile:<path> |
| /activate | Activates the product using the activation key. |
| /deactivate | Deactivates the product. |
| /analyzeindex | Analyzes and fixes indexes fragmentation. |
| /quiet (/q) | Hides all messages in console mode. |
| Argument | Description and usage |
|---|---|
| /exitcodes | Returns a list of possible exit codes that can be returned by the command-line process. |
| /key | Specifies the activation key. Usage: /activate /key:<activation_key> |
| Argument | Description and usage |
|---|---|
| /exitcodes | Returns a list of possible exit codes that can be returned by the command-line process. |
| Argument | Description and usage |
|---|---|
| /connection | Specifies a connection string. Usage: /connection:<connection_string> |
| /database | Specifies a database to manage indexes in. Usage: /database:<value> |
| /exitcodes | Returns a list of possible exit codes that can be returned by the command-line process. |
| /fixindexes | Specifies a path to the rebuild.sql file. Usage: /fixindexes:<path> If the path is specified, the rebuild script will be analyzed and generated in <path>rebuild.sql. If the path is not specified, indexes will be analyzed and fixed right in a database. |
| /indexrebuildonline | Overrides the “Online” global option. Usage: /indexrebuildonline:<On|Off> |
| /minindexsize | Specifies the minimum index size in pages and overrides the global option. Usage: /minindexsize:<value> |
| /password | Specifies a password and overrides the password specified in the connection string. Usage: /password:<pw> |
| /rebuildthreshold | Specifies rebuild the fragmentation threshold in % and overrides the global option. Usage: /rebuildthreshold:<value> |
| /reorganizethreshold | Specifies the fragmentation threshold in % and overrides the global option. Usage: /reorganizethreshold:<value> |
| /report | Generates index report in the CSV format. Usage: /report:<path>|<filename> |
| /tempdbsort | Overrides the “Sort in tempdb” global option. Usage: /tempdbsort:<On|Off> |