Andre Souza andrerocker

🤓

Clojure / SRE

andrerocker / sqlserver-dump-only-data.ps1

Created October 30, 2010 22:36

Powershell Script to: Export ONLY the data from yours SQLServer like mysqldump

	$database_host = "<host>"
	$database_name = "<database>"
	$output_file = "<output_file>"
	$user = "<username>"
	$password = "<password>"

	[system.reflection.assembly]::loadWithPartialName('Microsoft.SqlServer.SMO')
	$server = new-object "Microsoft.SqlServer.Management.Smo.Server" $database_host
	$server.connectionContext.loginSecure = $false
	$server.connectionContext.set_Login($user)

andrerocker / sqlserver-dump.ps1

Created October 30, 2010 22:12

Powershell Script to: Export all data from yours SQLServer like mysqldump

	$database_host = "<host>"
	$database_name = "<database>"
	$output_file = "<output_file>"

	$user = "<username>"
	$password = "<password>"

	[system.reflection.assembly]::loadWithPartialName('Microsoft.SqlServer.SMO')
	$server = new-object "Microsoft.SqlServer.Management.Smo.Server" $database_host
	$server.connectionContext.loginSecure = $false