Page History

...

For importing On-premises SQL Server instances, please use the on-premises template OnPremise.csv or use the following general rules and .csv file format.

• Enter or Browse SQL Server Instances cannot be null.
• Owner should be unique across an instance.
• Location should be unique across an instance.
• The next time the user uploads a record for the same instances, the Instance Tags / Database Name / Database Tags should be added to the existing IDERA SQL Inventory Manager data. But the Instance Owner and Instance Location should be updated with the new values.
• Comments
• Current Tags
• Add New Tag

Amazon instances

For importing amazon SQL Server instances, please use the SQL Inventory Manager import template for AWS instances or use the following general rules and .csv file format.

• Enter or Browse Amazon SQL Server Instances
• Owner
• Location
• Comments
• Current Tags
• DataBase Name
• Add New Tag
• AWS Account Name
• AWS Access Key
• AWS Secret Key
• AWS Region Endpoint

Azure instances

For importing On-premises SQL Server instances, please use the SQL Inventory Manager import template for Azure instances or use the following general rules and .csv file format.

• Enter or Browse Azure SQL Server Instances
• Owner
• Location
• Comments
• Current Tags
• DataBase Name
• Add New Tag
• Azure Account Name
• Azure Tenant ID
• Azure Client ID
• Azure Client Secret Key
• Azure Subscription ID
• Account Type

Importing a .csv file

To import a file:

...