dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Show-SqlDatabaseList

Shows a list of databases in a GUI. Returns a simple string. Hitting cancel returns null.

Screenshot

dblist

Examples

To show a GUI list of databases and uses Windows Authentication to log into the SQL Server. Returns a string of the selected database.

Show-SqlDatabaseList -SqlServer sqlserver2014a

To show a GUI list of databases and SQL credentials to log into the SQL Server. Returns a string of the selected database.

Show-SqlDatabaseList -Source sqlserver2014a -SqlCredential $cred

Get-Help

From PowerShell, execute Get-Help Show-SqlDatabaseList -Detailed for more information on this function.

Source Code

Want to see the source code? View Show-SqlDatabaseList.ps1 on GitHub
 

Related commands