tag:blogger.com,1999:blog-497787815177352569.post7004292864592893900..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: Downgrading A Database From SQL Anywhere 17 to 16Breck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-497787815177352569.post-17693687044241439072016-10-22T15:09:00.835-04:002016-10-22T15:09:00.835-04:00The BACKUP DATABASE TO statement can be used to cr...The BACKUP DATABASE TO statement can be used to create a single "archive backup" file. The RESTORE DATABASE statement must be used to restore from that backup.<br /><br />The dbbackup utility can only be used to create separate "image backup" files. Those files can be directly started as a database with no RESTORE statement required.Breck Carterhttps://www.blogger.com/profile/15975598564711761434noreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-65831025845108284862016-10-22T14:50:46.597-04:002016-10-22T14:50:46.597-04:00Can perform backup image xxx.1
I do the scjview
by...Can perform backup image xxx.1<br />I do the scjview<br />by command type Dbbackup?<br />because Dbbackup makes .db and .log<br />I wanted to do everything in one file<br />you tell me if it is possible?<br />Best regardsAnonymoushttps://www.blogger.com/profile/15380253674857076033noreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-48614804746061799732016-08-31T04:29:16.181-04:002016-08-31T04:29:16.181-04:00A large client asked the question after being disa...A large client asked the question after being disappointed in Version 17 performance even after installing an EBF that was supposed to fix the problems. The article was the result of a "preliminary investigation" into the downgrade technique ( it's tempting to call it "degrade" but that is actually the opposite of the desired effect: the purpose of the downgrade would be to improve performance, not degrade it :)Breck Carterhttps://www.blogger.com/profile/15975598564711761434noreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-47104780715226921322016-08-31T03:57:23.327-04:002016-08-31T03:57:23.327-04:00Interesting.. When going back I always expect the ...Interesting.. When going back I always expect the road to be rough<br />and the bridges to start catching fire.<br /><br />A few versions ago I remember me upgrading an empty database and<br />then comparing the unload/reload files of both versions with a<br />diff-tool to identify the stuff that needs to be cut out manually <br />for a downgrade.<br /><br />Any special reasons for you to go back? <br /><br />I myself haven't upgraded to 17 so far, because I found some <br />incompatibilities with dblib.dll when reading INOUT parameters from stored procedures.<br />This one will keep me on 16 for a while.<br /><br />Other than that I haven't run into problems with 17 so far.<br />Profiling and SQL Central in general are some massive improvements in 17.Anonymousnoreply@blogger.com