SSMA usage and diagnostic data collection

SQL Server Migration Assistant (SSMA) contains Internet-enabled features that can collect and send anonymous feature usage and diagnostic data to Microsoft.

Collected data

SSMA may collect standard computer information and information about use and performance that may be transmitted to Microsoft and analyzed for purposes of improving the quality, security, and reliability of SSMA. SSMA doesn't collect your name, address, or any other data related to an identified or identifiable individual. For details, see the Microsoft Privacy Statement, and SQL Server Privacy supplement.

Enable or disable usage and diagnostic data collection in SSMA

The following registry entry allows you to opt in or out of data collection:

  • RegEntry name = DisableTelemetry

    Entry type STRING: True is for opting out; False or not present is for opting in.

Additionally, automatic checks for newer tool versions during start-up can be disabled by adding the following entry:

  • RegEntry name = DisableAutoUpdate

    Entry type STRING: True is for opting out; False or not present is for opting in.

Depending on the migration source, the entry should be placed under one of the following registry keys:

  • For SQL Server Migration Assistant for Access:

    Subkey = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Migration Assistant for Access
    Subkey (32-bit application installed on 64-bit OS) = HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Migration Assistant for Access

  • For SQL Server Migration Assistant for DB2:

    Subkey = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Migration Assistant for DB2
    Subkey (32-bit application installed on 64-bit OS) = HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Migration Assistant for DB2

  • For SQL Server Migration Assistant for MySQL:

    Subkey = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Migration Assistant for MySQL
    Subkey (32-bit application installed on 64-bit OS) = HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Migration Assistant for MySQL

  • For SQL Server Migration Assistant for Oracle:

    Subkey = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Migration Assistant for Oracle
    Subkey (32-bit application installed on 64-bit OS) = HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Migration Assistant for Oracle

  • For SQL Server Migration Assistant for Sybase:

    Subkey = HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Migration Assistant for Sybase
    Subkey (32-bit application installed on 64-bit OS) = HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server Migration Assistant for Sybase