I have a Sybase db and I need to be able to extract data without the dba password. It is a database that is not used anymore and we are not using the vendor anymore so we don't have any means to get read only access. Any help would be greatly appreciated!!
If you have a SQL Anywhere database then you cannot extract any data from your database without a valid DBA userid and password for the database. There are no "back doors" that will allow you to get the data.
If the database was created using a third-party software application then you should contact the vendor of that application in order to get the data out of the database.
If you can prove that the database belongs to you and that you have the rights to the data then Sybase Tech Support may be able to help you get a dump of the data in the SQL Anywhere database, but if the data is encrypted and you do not have the encryption password then there is no method of getting any of the data.
To contact Tech Support click on the "Contact Us" link at the bottom of this page and then click on "Support Contacts" on the right panel.
answered 23 Jul '11, 03:38