Page Comparison

...

In the directory where you downloaded the application, create a new file called servers.csv with the connection strings required details for all of the SQL Server instances you would like to collect data from. This file can be created with Notepad, Excel, or any text editor. One Each SQL Server instance should be one per have its own line, and there is no limit to the number of SQL Servers.

The recommended connection string csv format for each instance is:

sqlserver://username:password@host:port/instance

The following connection string URL formats are also supported

• sqlserver://username:password@host/instance?param1=value&param2=value

• sqlserver://username:password@host:port?param1=value&param2=value

• sqlserver://sa@localhost/SQLExpress?database=master&connection+timeout=30 // SQLExpress instance.

• sqlserver://sa:mypass@localhost?database=master&connection+timeout=30 // username=sa, password=mypass.

• sqlserver://sa:mypass@localhost:1234?database=master&connection+timeout=30 // port 1234 on localhost.

• sqlserver://sa:my%7Bpass@somehost?connection+timeout=30 // password is "my{pass"

The connection string can also be provided in ADO and ODBC format, examples as follows:

...

server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName

...

server=localhost;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost\\SQLExpress;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost;user id=sa;database=master;app name=MyAppName

...

odbc:server=localhost;user id=sa;password={foo;bar} // Value marked with {}, password is "foo;bar"

...

odbc:server=localhost;user id=sa;password={foo{bar} // Value marked with {}, password is "foo{bar"

...

odbc:server=localhost;user id=sa;password={foobar } // Value marked with {}, password is "foobar "

...

odbc:server=localhost;user id=sa;password=foo{bar // Literal {, password is "foo{bar"

...

odbc:server=localhost;user id=sa;password=foo}bar // Literal }, password is "foo}bar"

...

odbc:server=localhost;user id=sa;password={foo{bar} // Literal {, password is "foo{bar"

...

ipOrDNS,portOrInstanceName,username,password,database

The tool will use this information to build connection strings to retrieve the necessary data.

Run sqlserver-telemetry

Windows

...