Migrating Sybase SQL Anywhere version 7 to 17

[former_member27]

Is there any program that can migrate version 7 to the latest version? Is that even possible? The system is currently running in a virtual box under Windows 2000.

[former_member27]

Hi tcocklin,

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

You should also make sure your e-mail notifications are turned on for "Comments and answers to my questions and questions I follow" at #communications -- so you won't miss any replies to your question.

In addition, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it. That also means making sure you don't include unrelated tags. Members frown on over-tagging if the content isn't relevant to their interests, as the post will show up in their Q&A feeds and they get annoyed when the question isn't really about a tag that they follow.

Should you wish, you can revise your question by selecting Actions, then Edit.

One last thing: If you're interested in connecting with community members, please pay a visit to our new Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and get to know other experts!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

--Dedi

[chris_keating]

How to Upgrade to the Latest Version of SQL Anywhere | SAP Help Portal

SQL Anywhere is capable of upgrading any version of database file to SQL Anywhere 17. You will need to know the credentials for an user with DBA authority. For example, the user DBA should have that authority.

In short, you can use the dbunload command line tool or SQL Central Unload Database Wizard to perform the work. But please review the relevant sections for Upgrades of Version 9 and earlier databases of the documentation linked above.

Rebuilding the database is generally straightforward. There may be behavior changes that you will need to address. This changes is documented earlier in the same documentation link - see the Table of Contents.

As an aside, Windows 2000 is not a supported platform. I assume that you will want to get a more current operating system also.

[Javier-Martin]

Hi Tim,

SAP Advanced SQL Migration tool (your have tagged your question with it) is not the right tool in this case because it is a tool to convert SQL data models from non-SAP databases to SAP databases.

My suggestion for you is to check the official upgrade procedures for SQL Anywhere, version 7 is a pretty old version so you probably have to do it more than one step because version 17 may not be supporting upgrading from version 7. Please check the following notes for further details:

3073349 - Recommended way to upgrade SQL Anywhere &

217114 - How to upgrade to SQL Anywhere 17

I also suggest you to check SQL Anywhere manuals as well.

Regards.

Javier Martin.