How to convert PERSSQL.dat, NAMEDSQL.dat, and SQLS.dat files from older versions of Toad to SAVED (13522)

With TOAD 7.3 and older, the *.dat files that contains the user's SQL statements cannot be converted correctly in TOAD 8.6.

The *.dat files in TOAD 7.4 to 8.0 inserts an extra line that TOAD 7.3 and prior versions does not have. So TOAD 8.6 will not accept the *.dat files unless they are modified to look like the *.dat file used in TOAD 8.0.

WORKAROUND:

Refer to the attached file, Sol13522.swf, to view a short flash file that will walk you through the following steps.

The following steps will convert the *.dat files from TOAD 7.3 (and older) for use in TOAD 8.6:

1) Exit out of TOAD 8.6.
2) Rename your SAVEDSQL.xml file to SAVEDSQL.xml.old.
3) Open your SQLS.dat file from TOAD 7.3. You should see a series of queries, listed like this:

select * from blah4
///
select * from blah3
///
select * from blah2;
///
select * from blah;
///

Change the entries to look like this and save the changes.

select * from blah4
#TOAD#/\#TOAD#
///
select * from blah3
#TOAD#/\#TOAD#
///
select * from blah2;
#TOAD#/\#TOAD#
///
select * from blah;
#TOAD#/\#TOAD#
///

4) Now open the PERSSQL.dat file and repeat step 1. You do not need to do this with the NAMEDSQL.dat file.
5) Now that you have modified your PERSSQL.dat and SQLS.dat files, copy these files into the TOAD root directory.
6) Copy the NAMEDSQL.dat file into the %TOAD\User Files directory.
7) Launch the TOAD application.

Now all of the .dat files should disappear. You can view all of your queries in the newly generated SAVEDSQL.xml file by going to View | SQL Command Recall.

STATUS:

Waiting for fix in a future version of Toad for Oracle