English 中文(简体)
I have a sybase database in a file. How do I determine for which version of sybase it is for?
原标题:
  • 时间:2010-01-22 10:27:15
  •  标签:
  • sybase-asa

I ve been handed a file which appears to me to be a Sybase database file from some older Sybase version. I have d-loaded the latest sybase package from sybase and tried using that to connect to the contents but failed. Can someone suggest to me how to determine which version of sybase (and perhaps even which sybase db product) my file represents?

This is how the beggining of the file looks in a text editor:

I ě ^şzÚ ÖK n´Ą ÍĄ YŘ l f ˙˙˙˙˙˙˙˙ ˙˙˙˙˙˙˙˙WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, 1994 WATCOM International Corp., Copyright (c) 1987, BASEN j ‘ Ă™pGđČžrEđÇšmAę»b4Ô¨~PHŽ j $ ¨ ýŰ ë HolBASENş omain_name from SYS.SYSDOMAIN where domain_id=SYSCOLUMN.domain_id), nulls,width,scale,pkey,column_id,"default", SYSCOLUMN.remarks from SYS.SYSCOLUMN join SYS.SYSTABLE7€f SYSCOLUMNSVIEW˙create view SYS.SYSCOLUMNS(creator,cname,tname,coltype,nulls,length, syslength,in_primary_key,colno,default_value,remarks) as select(select user_name from SYS.SYSUSERPERM where user_id=SYSTABLE.creator), column_name,table_name, (select d · NŃ €e SYSUSERPERMSVIEWŁcreate view SYSUSERPERMS as select user_id,user_name,resourceauth,dbaauth,


Thanks!

Filip

最佳回答

Any database created with any version of SQL Anywhere (or Watcom SQL) up to and including version 9 can be used with a version 9 SA server. If you have a version 10 or 11 server (version 12 is in beta right now), you need to unload it and reload it before the version 10/11 server can run it.

Note that SA version 9 will be end-of-life d in (checks watch) 11 days.

问题回答

As an alternative you can download older versions of sybase and try to connect to the given file.





相关问题
How to output data from iSQL to csv file _with_ headings?

I m trying to query a Sybase ASA 8 database with the iSQL client and export the query results to a text file in CSV format. However the column headings are not exported to the file. There is no ...

Sybase SQLAnywhere jConnect routines?

I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn t ...

How to insert into a temporary table?

I m working with Sybase Central using Adaptive Server Anywhere 9 and I want some examples of how to use tempDB. How can I insert some records in to a temporary table? I tried: select * into TempDB....

热门标签