Sample Header Ad - 728x90

Import Sybase SQL Anywhere 8 DB into SQL Server without access to Sybase

0 votes
0 answers
533 views
This is my first post here and its a doosy. I am facing what seems to be a unique situation at the moment. I am in the process of moving my client to a new environment which includes decommissioning super old equipment. One of the last remaining pre-2008 servers is Windows 2000 IBM server running a Sybase SQL Anywhere 8 database with Jaguar. Since this server is so old and still in light use, my primary concern was taking a full backup of data in the event of failure. The OS on this server is in bad shape and running any exe causes it to hang, so I could not install any third-party backup. I took a full drive and state backup with the native windows backup utility (in safe mode) into a bkd file. After taking a backup now the Jaguar service always hangs on start, so its essentially broken. Rather than fix a 2000 server I want to find a way to get this old database onto a new server. I restored that backup to a temp 2008 VM by copying the dlls for NTBackup off of the 2000 server so it could hand bkd. This way I could experiment on a non-prod copy of the data. As one would expect the software doesn't work on a restored copy, partly due to 2000 using WINNT in place of system32, so my focus has shifted to converting the Sybase db file to SQL Server. I did find "Stellar Converter for Database" and ran the db file through that on a trial as a proof of concept and the data preview is in fact readable, but unfortunately I don't think my client will pay the $200. It seems well worth it, but my hands are tied on that front. I also found the Microsoft "SQL Server Migration Assistant for Sybase" and it seems promising, however it requires I connect to the Sybase db itself, which I cannot do since it is broken. I also tried searching the internet for a download of SQL Anywhere 8 or 9 with no luck. I did find 12, but it was client only. The previous IT also did not document the logins for this database at all, so its looking grim. Does anyone have any pointers on options to get this Sybase 8 .db file into a Microsoft SQL Server 2017 (I have ISOs of older ones on hand) .mdf file without access to the actual old db server, and without any credentials? I know I recently reset an SA account on another of our old SQL Servers by putting the db in offline mode and running some sqlcmd magic, but I am no way familiar with Sybase. I do not have high hopes and I am fully aware that the answer may be "its dead Jim". I appreciate any input, even if its not what I want to hear.
Asked by rrrrowsdower (1 rep)
Mar 27, 2020, 03:45 PM
Last activity: Mar 28, 2020, 09:48 AM