Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Anywhere - Upgrade a DB

Posted on 2009-05-06
3
Medium Priority
?
1,784 Views
Last Modified: 2012-05-06
SQL Anywhere is throwing the following error:

Could not connect to the database.

Unable to start specified database: 'C:\X20\Documents\shopmate.db' was created by a different version of the software
[Sybase][ODBC Driver][SQL Anywhere]Unable to start specified database: 'C:\X20\Documents\shopmate.db' was created by a different version of the software
      Error code=-1005
      SQL state=08001

DB is version 8.0.2.360, I'm running 11.0.1.

dbupgrad fails with the same error.

dbunload fails with "Unable to start specified database: autostarting database failed"

Attempting to start server fails, yet upgrade through Sybase Central won't start unless connected.

What is the trick here?
0
Comment
Question by:kwebster7327
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 2000 total points
ID: 24327614
You cannot jump from 8 to 11 in one shot.  I would look for a version of 9.x and go there first.  I think you can jump from 9 to 11 O.K though.

Regards,
Bill
0
 
LVL 1

Author Comment

by:kwebster7327
ID: 24330094
Good plan, but alas! Migrated DB won't open open in 11. Works in 9, though.

Guessing I need to step it through 10, too.
0
 
LVL 19

Expert Comment

by:grant300
ID: 24330591
Kind of a pain but at least you have a way to make it happen.

Regards,
Bill
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question