I have a client that is asking me to convert a vertical market application from their old program to ours. The old application uses Sybase SQL Anywhere and mine uses SQL Server. They provided the .DB but there is no log file available.
I have downloaded ASA 9 and have it running. But when I tried to load the database, it says the log file is missing and it won't open. How can I get beyond this problem? (We're not worried about losing data in the db.)
First of all.. Good luck converting ASA to SQL Server..
Pat: if you are listening, I think we need separate forums for ASE, ASA and IQ.... We simply dont have bandwidth to support ASA and IQ.
for the OP... This is mostly an ASE forum. Theres 3 major databases from Sybase which unfortunately have 3 different syntaxes / concepts.
ASE - Adaptive Server Enterprise - Sybase OLTP database which MS upgraded / deviated from.
ASA - Adaptive Server Anywhere - Sybase mobile database which they acquired a few years ago.
IQ - Adaptive Server IQ - Sybase Datwarehousing product which they acuired a few years ago.
Due to the lack of Sybase people around... everything is being dumped in one single forum, which is not that good, in my opionion... Pat? Would appreciate ur comments..
Starting with the original poster's question: You ought to be able to use the ASA 9.0 utilities to recover the DB file. Once you do that, you can use ODBC to access the data in the ASA database from DTS (for MS-SQL 2000) or SSIS (for MS-SQL 2005). Once you can do this, you can recover the data and the table definitions (and maybe the DRI too) from the ASA database
Vishi has raised a two-edged sword reguarding Sybase forum support. Your analysis is correct, ASE is the "original" Sybase product, the database engine that has been with the company since the inception of them both. ASA is Adaptive Server Anywhere, which was formerly Waterloo SQL. Sybase IQ is largely unknown, even by Sybase representatives (the folks in the Sybase booth at a recent trade show didn't recognize IQ as a Sybase product, they claimed it was a "third party" product until I pointed it out in their own literature).
The problem is that at least compared to other database products, there aren't a whole lot of Sybase users actively participating in forums anywhere on the internet. I'm pretty sure that DBForums could provide separate forums for each Sybase product, but that would further divide the user base making support that much harder for new users (like the OP, bjones8888) to find and I think that would be a very bad thing.
I'm open to suggestions, but I think that the Sybase users would be better off working together than splitting up, reguardless of which product (ASE, ASA, IQ, or other) that they use.