• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1067
  • Last Modified:

Sybase SQL Anywhere 5.0 to MS SQL

We are looking to export tables from a sybase sql anywhere 5.0 database to ms sql. Does anyone know of any free utilities or easy methods to get this accomplished?
0
menreeq
Asked:
menreeq
  • 2
2 Solutions
 
PortletPaulCommented:
Won't SQL Sever Migration Assistant (SSMA)  work for this combination?

v6.0 download
http://www.microsoft.com/en-us/download/details.aspx?id=43691

{+edit} SSMA does specify Sybase ASE, so I'm just no sure about "SQL Anywhere" - Sybase versions isn't something I'm that familiar with - sorry.
0
 
menreeqAuthor Commented:
Correct, this will definitely work. The trouble is procuring the correct ODBC drivers to connect to the sybase database.  We have the database credential just dont have the drivers.
0
 
menreeqAuthor Commented:
both odbc drivers and the SSMA tool are required.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now