dbTalk Databases Forums  

Can I open a v9 db with sqlanywhere 12? Other questions

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Can I open a v9 db with sqlanywhere 12? Other questions in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
mat
 
Posts: n/a

Default Can I open a v9 db with sqlanywhere 12? Other questions - 05-20-2011 , 06:12 PM






I need to work with a sybase 9 database. They sent me a .db and a .log
file. I work more with sql server, and if I had a mdf and a ldf I'd
attach them to get the db to function. I installed sqlanywhere 12 and
was hoping to see some kind of "attach" choice offered by the ide but
couldn't find one. Can someone point me to it?

I gather that I'd need to upgrade the v 9 file to a later version before
I could open it in sqlanywhere 12. Is that more or less a painless
process? If it's hard I have both sqlanywhere 10 and 9. I'm working on a
64 bit box now and my old sqlanywhere 9 is 32 bit only, and I can't find
a download location for x64 sqlanywhere 9. Would it be simpler to use
sqlanywhere 10, or 12, on this v 9 db?

All I need to do is to link to the data via odbc. For that I do need to
'mount' the db, ie attach it, to a sqlanywhere instance, right? I can't
just tap the data via odbc?

Reply With Quote
  #2  
Old   
tduemesnil
 
Posts: n/a

Default Re: Can I open a v9 db with sqlanywhere 12? Other questions - 05-23-2011 , 03:24 AM






You have to convert the database.
Version 10 was the only version where you are no able to load a older
Database File with a actual Server engin.
You should be able to run the Convert with the 64bit Version. There is
no difference between 32bit and 64bit in the DB File.

You can Unload/Reload the Database with Sybase Central

HtH

Reply With Quote
  #3  
Old   
mat
 
Posts: n/a

Default Re: Can I open a v9 db with sqlanywhere 12? Other questions - 05-23-2011 , 10:01 PM



In article <9d08f697-7f84-44df-b144-9105b8b0f0a6
@l30g2000vbn.googlegroups.com>, tduemesnil (AT) googlemail (DOT) com says...
Quote:
You have to convert the database.
Version 10 was the only version where you are no able to load a older
Database File with a actual Server engin.
You should be able to run the Convert with the 64bit Version. There is
no difference between 32bit and 64bit in the DB File.

You can Unload/Reload the Database with Sybase Central

HtH
Thanks for this input, it does help.

Any chance of getting a step by step on this? I have a chicken and egg
scenario, it seems. In Sybase Central 12, both options Migrate Database
and Upgrade Database won't work unless I'm already connected to the db.
You said "Convert" but between the two options Migrate and Update I am
not sure which it is.

I can't find any info on Reloading a db or Loading it (from the db and
log files I have) using Sybase Central...so effectively I can't do
anything. I know there is a way.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.