Sybase SQL Anywhere 5.0 to MS SQL

Posted on 2014-08-20
Last Modified: 2014-09-23
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?
Question by:menreeq
    LVL 47

    Accepted Solution

    Won't SQL Sever Migration Assistant (SSMA)  work for this combination?

    v6.0 download

    {+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.

    Assisted Solution

    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.

    Author Closing Comment

    both odbc drivers and the SSMA tool are required.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now