SQL Anywhere Integration

• Michele.Galloway

  SSC Rookie

  Points: 39

  More actions

  December 7, 2005 at 6:21 am

  #166802

  I would like to integrate a SQL Server and SQL Anywhere database. I want to read the SQL Anywhere database and data stored in SQL Server to create reports and metrics. Can SQL Server link to SQL Anywhere tables? I'd rather not synchronize data if I don't have to.

   

  mpg

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  December 7, 2005 at 11:03 am

  #608232

  I had to do this once a few years back.  Here is a good artical that goes over the creation of a data source to SQL Anywhere.

  http://www.aspfree.com/c/a/MS-SQL-Server/Using-DTS-Import-FromExport-To-a-NonMicrosoft-Database/2/