I asked exactly the same question.
http://forum.cakewalk.com/tm.asp?m=888655&mpage=1&key= The only way to scale tempo in Sonar is Fit To Time.
I sent email to CW and got the answer from Tom Roussel.
--------------
As you know, there is no Scale Tempo command that lets you determine the new tempo by scaling. However, a little simple math will give you the new Thru time and you can use it in the Fit To Time command.
For example, suppose your song is currently at 106 BPM. You want to
increase it to 108 BPM. Since the increased tempo will mean a shorter
song length, and thus a sooner Thru time, you divide the current tempo
by the new tempo and multiply the result times the Current Thru time.
Lets say your song is exactly 60 seconds long at 106 BPM and you want
to
increase it to 108 BPM. What is the new Thru time?
(106/108) * 60s = 58.9s
If you want to decrease tempo, you swap the tempos and divide the new
tempo by the current tempo and still multiply the result times the
current Thru time.
(108/106) * 60s = 61.1s
--------------------
I understand all these calculations, but there is a problem. With above formulas we have results expressed in seconds. Fit To Time command requires HH:MM:SS:FF. From example above, if I have New Thru = 61.1 seconds, what do I have to enter in New Thru field in Fit To Time window?
Tom did not answer me this question. Strangely enough, in the web, there is absolutely no sign of a calculator for conversion between absolute time and SMPTE.
So, the question "How to scale tempos in Sonar?" remains unanswered.