Running scripts using TOAD through Editor

Provide the source path and the destination path and execute the script from Editor > Execute as Script.

  • For example to run PSFT FI script using TOAD via Editor

    @'C:\PSFTAI\ExtractPSFTFISCMAI.SQL' 'C:\PSFTFISQLEDT' 'ENG' 'ENG' 'SYSADM' 'FINC' 'ENGLISH' 'ENGLISH'

    Note: C:\PSFTAI\ExtractPSFTFISCMAI.SQL is the location of SQL script and C:\PSFTFISQLEDT is the location for extracted data.
  • For example to run PSFT HR script using TOAD via Editor

    @'C:\PSFTAI\ExtractPSFTHRMSAI.SQL' 'C:\PSFTHRSQLEDT' 'ENG' 'ENG' 'SYSADM' 'PSHCM' 'ENGLISH' 'ENGLISH'

    Note: C:\PSFTAI\ExtractPSFTHRMSAI.SQL is the location of SQL script and C:\PSFTHRSQLEDT is the location for extracted data.
    Note: Codeless extraction may fail if some unknown unicode characters are not parsed.