How can we help you today? How can we help you today?

Feature request: include column header names in CVS files

I love Multi Script, since it allows me to collect similar data from many databases at a time.

I wish it had an option to include the column headers in the CSV files. This would be similar to SQL Management Studio's ability to include headers when copying or saving results shown in the grid.

Currently, if I wish to assemble a nice Excel file with headers, I execute my query manually on a single server, and save the grid output with headers. Then I run Multi Script on all servers, and transfer the headers from the first file to the Multi Script file.
weswinkler
0

Comments

3 comments

Sort by
  • HJoyce
    Thanks for this feedback. It is already logged (SE-637).
    HJoyce
    0
  • Linda Hawksworth
    I hope you will be pleased to hear that we have a patch for SQL Multi Script where the CSV file had no column headers. Please download it from:

    ftp://support.red-gate.com/patches/SQL_ ... 2.0.28.zip

    and confirm it fixes your issue.
    Linda Hawksworth
    0
  • tkdennis
    That works great! Any chance we could get a "Copy with Headers" for the right-mouse menu? It currently has Copy and Select All.

    Thanks,
    Traci
    tkdennis
    0

Add comment

Please sign in to leave a comment.