I need to recover data from a Sybase SQL Anywhere 12 (I have an *.db file) into MS SQL Server 2008.
I installed the SQL Anywhere 12 Developer kit and that allowed me to run the database and installed ODBC drivers that should have allowed me to do this. I managed to use the SQL Server Import/Export wizard to import a single table by typing in an SQL statement, the import all data functionality was disabled.
Since I have a hundred or so tables, I'd like to find a tool to automatically do the import for me, for all tables. Are there any free tools or scripts out there for this?