Linked Sybase from SQL Server

[former_SQLA_member1694872]

How do I create (step by step) one sybase linked server to SQL Server In ODBC not appear Ole Provider driver for creation of Alias I do not know where to start. :( I am using Sybase ASA 9 and SQL Server 2012

[VolkerBarth]

What I want to do is insert ASA database data in SQLServer database.

Will this be a regular activity or just a one-time action (say, for data migration purposes)?

Breck has written several blog articles on data transfer between SQL Anywhere and MS SQL Server, cf. these:

• In-Memory Downloading from SQL Server (1) - and the further parts listed there
• UNLOAD SELECT BULK INSERT - that does not use proxy tables, but unload and the FORWARD TO statement to execute real MS SQL statements directed from the SQL Anywhere side...

I can't tell whether they will apply to your situation but just wanted to show that there are possible further methods available than one might think of...