Copy data from tables and output to CSV files
Do you want to copy out the content of your database tables?
This little powershell utility uses the bulk copy command (bcp) to extract the data from your MSSQL database tables and put the result into a set of csv files, one for each table.
Just enter the details of where you want the data saved, your server name, userid, password and database name at the top of the script; you must use SQL authorisation not windows authorisation in order for the bulk copy command to work.
It is slightly resource heavy, but can be used while other work is continuing. It uses the powershell pscx bundle found at https://pscx.codeplex.com and this must be installed on your server! Please check and get the correct version of pscx for your version of powershell.
Operating systems:
Windows 7, Windows 2003, Windows Server 2008
Additional requirements:
Powershell pscx addon
Date:
01.08.2014
Похожие программы
