powershell 遍历数据库表导出为csv

最新推荐文章于 2023-11-27 22:47:51 发布

_iorilan

最新推荐文章于 2023-11-27 22:47:51 发布

阅读量1.5k

点赞数 1

分类专栏： Vs Development

本文链接：https://blog.csdn.net/lan_liang/article/details/104495000

版权

Write-Output 0
$server = ".\"
$database = "dbname"
$tablequery = "SELECT schemas.name as schemaName, tables.name as tableName from sys.tables inner join sys.schemas ON tables.schema_id = schemas.schema_id"
Write-Output 1
#Delcare Connection Variables
$connectionTemplate = "Data Source={0};Integrated Security=SSPI;Initial Catalog={1};"
$connectionString = [string]::Format($connectionTemplate, $server, $database)
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connectionString
Write-Output 2
$command = New-Object System.Data.SqlClient.SqlCommand
$command.CommandText = $tablequery
$command.Connection = $connection
Write-Output 3
#Load up the Tables in a dataset
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $command
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)
$connecti