SQL Data Catalog

Copy

 $authToken = "[Your auth token]"
$serverUrl = "http://[Your SQL Data Catalog Server FQDN]:15156" # or https:// if you've configured SSL
$instanceName = 'sql-server1.domain.com'
 
Invoke-WebRequest -Uri "$serverUrl/powershell" -OutFile 'data-catalog.psm1' `
    -Headers @{"Authorization" = "Bearer $authToken" }
 
Import-Module .\data-catalog.psm1 -Force
 
# connect to your SQL Data Catalog instance - you'll need to generate an auth token in the UI
Connect-SqlDataCatalog -AuthToken $authToken -ServerUrl $serverUrl
 
Export-Classification -instanceName $instanceName -exportFile "myfile.csv" -format 'csv'

Export%20single%20CSV%20file%20for%20all%20databases%20on%20an%20instance.ps11:13

	$authToken = "[Your auth token]"
	$serverUrl = "http://[Your SQL Data Catalog Server FQDN]:15156" # or https:// if you've configured SSL
	$instanceName = 'sql-server1.domain.com'

	Invoke-WebRequest -Uri "$serverUrl/powershell" -OutFile 'data-catalog.psm1' `
	-Headers @{"Authorization" = "Bearer $authToken" }

	Import-Module .\data-catalog.psm1 -Force

	# connect to your SQL Data Catalog instance - you'll need to generate an auth token in the UI
	Connect-SqlDataCatalog -AuthToken $authToken -ServerUrl $serverUrl

	Export-Classification -instanceName $instanceName -exportFile "myfile.csv" -format 'csv'

SQL Data Catalog

Example: Exporting a single .csv file for all the databases on an instance

Cookies on red-gate.com