• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1805
  • Last Modified:

SQL Anywhere - Upgrade a DB

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
kwebster7327
Asked:
kwebster7327
  • 2
1 Solution
 
grant300Commented:
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
 
kwebster7327Author Commented:
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
 
grant300Commented:
Kind of a pain but at least you have a way to make it happen.

Regards,
Bill
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now