Export devices

Use the export functionality to migrate data or to consolidate databases.

  1. Start Snow Inventory Server Configuration Manager (run snowserverconfig.exe).

  2. On the Welcome page of the Snow Inventory Server Configuration Manager, select Click here for additional options…

  3. In the Additional options dialog box, select Export devices.

  4. In the Database step:

    1. Enter a Name or a network address for the SQL server instance to be used.

    2. Enter the Name of database to be exported.

    3. Select one of the following authentication alternatives:

      • Select the Use Windows Authentication check box.

      • Enter User ID and Password of an SQL user account with read permissions on the database.

    4. To add additional settings for the database connection, select the Use these additional connection string properties check box and enter the properties in the box that is displayed. Use semicolon as delimiter.

  5. Select Next.

    Database.jpg
  6. In the Export database step:

    1. Enter the path to the Output folder for the export file, or select Browse.jpg to browse for the folder.

    2. To only export data which matches a specific site name, enter a site name in Filter by site name. It is possible to use wildcards and patterns as per the syntax of the LIKE operator in Microsoft T-SQL. This field is optional.

    3. To only export data which matches a specific device name, enter a device name in Filter by device name. It is possible to use wildcards and patterns as per the syntax of the LIKE operator in Microsoft T-SQL. This field is optional.

    4. Use the Limit historical data to at the most option to set a limit for export of information, such as metering and login history.

  7. Select Export.

    export_database.png
  8. When the information has been exported, select Finish.