Free tool to migrate from Sybase SQL Anywhere 12 to MS SQL Server 2008 [closed]
开发者_如何学Go
Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 8 years ago.
Improve this questionI 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?
Take a look at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f39d6150-e611-46e1-84c5-0808010711c8&displaylang=en
I'm not very keen on Sybase versions, but maybe it is what you are looking for
Unfortunatly there isnt any freewhere tools to do it, however, one trick I use is to migrate the data from Sybase into Access (using ODBC), and then upsize from there to SQL Server.
精彩评论