orourke.tv - vendors:microsoft:sql

migrate-std-to-dev

anonymous@undisclosed.example.com (Anonymous) — Mon, 20 May 2024 08:10:23 +0000

Migrate to SQL Developer Edition If you installed a full edition (e.g. standard or enterprise edition) in a lab environment and you need to migrate to developer edition - these are the steps to follow. Reference: * Create a Full backup of all user and system databases. Ensure that the backup completes successfully before continuing.

sqlcmd

anonymous@undisclosed.example.com (Anonymous) — Tue, 14 May 2024 16:42:42 +0000

SQLCMD * sqlcmd -S MyServer -d myDB -E -Q "select col1, col2, col3 from SomeTable" -o "MyData.csv" -h-1 -s"," -w 700 -h-1 removes column name headers from the result -s"," sets the column separator to , -w 700 sets the row width to 700 chars (this will need to be as wide as the longest row or it will wrap to the next line)