Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#462 Create Data script to File

open
Gerd Wagner
5
2013-08-09
2012-11-08
Anonymous
No

If the DB has million of rows, generating script to Editor will break it due to not enough memory. Anyway, there is no editor which can hold million rows. It is nice to have an options of generate the script to file

Many thanks.

Discussion

  • Gerd Wagner
    Gerd Wagner
    2012-11-08

    This should be relatively easy to do by adding a new radio button "Export insert/values statements" to our "Store result of SQL to file" dialog. The "Store result of SQL to file" functions should already be able to write millions of rows in CSV format. Writing insert/value format instead should be easy to implement with the help of our regular scripting functions.

    Just in case somenone wants to do donate a patch. ;-)

     
  • We just get into this issue; It would be great to have a feature like Gerd suggested.
    +1

    Simone