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

sqlserver-dump.ps1

$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)
$server.connectionContext.set_Password($password)

$database = $server.databases[$database_name]
$database.script() | out-file $output_file

$scripter = new-object "Microsoft.SqlServer.Management.Smo.Scripter" $server
$scripter.options.appendToFile = $false
$scripter.options.scriptData = $true
$scripter.options.includeIfNotExists = $true
$scripter.options.includeHeaders = $true

$scripter.options.indexes = $true
$scripter.options.withDependencies = $true

$scripter.options.toFileOnly = $true
$scripter.options.fileName = $output_file

$tables = $database.tables 

foreach ($s in $scripter.enumScript($tables)) { write-host $s } 

How-to export 100 rows (for eg.) each table in database, not all data ?