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.

asked 30 Apr, 12:29

lferreira's gravatar image

lferreira
86569
accept rate: 0%

1

How distant are these database system? How much latency is acceptable here, and would much concurrent access is acceptable?

Besides the MobiLink approach you have already mentioned, in case the database servers can be connected directly, you might also

  • use proxy tables within SQLA linked to the MS SQL database, or
  • use MS SQLs Linked Server feature to access SQLA tables,

either to periodically update the separate data on the MS SQL site or to let MS SQL access SQLA's data directly.

If direct access is not possible, using web services/OData might also do the trick.

(30 Apr, 12:54) Volker Barth
Replies hidden

Database servers are not connected, SQLA is in the cloud and MSSQL is on- premise, also SQLA has a high workload and concurrency and I don't want MSSQL reports to access SQLA. I don't think the latency is an issue, we can agree with the customer updated the data in MSSQL multiple times during the day.

(30 Apr, 13:59) lferreira

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

permanent link

answered 30 Apr, 12:59

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.1k340110
accept rate: 38%

1

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.

(30 Apr, 14:08) lferreira
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×362
×55

question asked: 30 Apr, 12:29

question was seen: 99 times

last updated: 30 Apr, 14:08