General discussion
-
Topic
-
Microsoft SQL Server and Sybase SQL 11.9
LockedI am currently working on a project that warrants a COMPLETE database rewrite. The ‘tunnelvision’ of this project is to take a database from a Sybase 11.9 store on a SunSparc, import it into a MS SQL Server 7.0 database (same schema and data) then convert it into a fully relational MS SQL v7.0 database. Looks good on paper!
I cannot seem to get the Sybase database to open under ANYTHING on the MS side. I have tried the ODBC with the Sybase ODBC DLLs for Sybase 11.9 but that only produces error messages. The funny thing is that if I use the wrong password, it tells me that login was incorrect…but if the password IS correct it won’t acknowledge anything else.
I know that this is sort of a vague question so lets just sum it up like this, what is the EASIEST way to take a SyBase 11.9 database on a SunSparc (RAW data) and import it into a MS SQL database with the same schema and data?
Thank You