cancel
Showing results for 
Search instead for 
Did you mean: 

Replication from SQL Anywhere to Microsoft SQL Server

0 Kudos
8,265

I have a customer that needs to replicate a set of tables from SQL Anywhere 17 to MS SQL Server, anyone with experience in this?

The only information found in this regard is the following: https://answers.sap.com/questions/11656739/replication-from-sql-anywhere-to-microsoft-sql-ser.html

The real goal of replication is to replicate data from a existing production SQLA database to a reporting database on MSSQL Server, the source is SQLA and MSSQL as a target. I did the tutorial using MS SQL Server as consolidated database and was able to replicate successfully, creating a remote database on SQLA, using "upload to consolidated only" option. I am not sure if this is the best option, I see that Mobilink can only replicate to SQLA and Ultralite as a remote database and in this case my remote database is MSSQL. I think Mobilink is designed for another type of replication solution. Any comments or help would be great.

View Entire Topic
regdomaratzki
Product and Topic Expert
Product and Topic Expert

MobiLink will work fine for this, as long as you don't want to synchronize the data from one SQL Anywhere database to multiple MSSQL database databases. Why does it matter that MobiLink considers the MSSQL DB to be the "consoldiated" and SQL Anywhere as the "remote" if your goal is just to keep data the same between two databases?

Reg

Yes, that's correct, it doesn't really matter as long as the data is replicated in this way (SQLA->MSSQL) and SQLA performance is not affected. I'll keep testing to see how it goes, thanks.