Download the project
START ===== C:\Temp\ExportDb.cmd
echo THIS CMD SCRIPT NEEDS SQLCMD IN YOUR PATH
ECHO PURPOSE: EXPORT THE LIST OF ALL TABLES INTO A TABLESLIST NAMED FILE
ECHO AND FOREACH LINE ( A TABLE NAME ) OF THE FILE EXPORT THAT TABLE TO A FILE
@echo off
sqlcmd -S hostName\instance_name -U userName -P password -d DataBaseName -Q "set nocount on;select name from sys.tables" -o "TablesList.csv" -s"|" -u -r1 -e -W -w4000 -h-1 -b -e
for /f %%i in ('type TablesList.csv') do ExportTable.cmd %%i
pause
END ================== C:\Temp\ExportDb.cmd
.
START ===== C:\Temp\ExportTable.cmd
set TableName=%1
sqlcmd -S hostName\poc_qa -U userName -P password -d cas_dev -Q "set nocount on;select * from %TableName%" -o "%TableName%.csv" -s"|" -u -r1 -e -W -w4000 -h-1 -b -e
END ================== C:\Temp\ExportTable.cmd
Posts
Getting the Current TabItem when the Tab is not selected in WPF
-
[image: Banner]
This is a quick reminder to self on how to retrieve a TabItem from a WPF
TabControl *when the tab is not currently selected* because I ru...
1 month ago
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!