SQL Anywhere to MSSQL replication

[former_member818570]

I want to develop an application for my client, for that I have to replicate or synchronize SQL Anywhere data to MSSQL. I couldn't get any tutorials for this. Looking for a tutorial long time.

I am just a beginner in this, hence couldn't understand some documents. It will be a great help if you can guide me with this.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

[Mark_A_Parsons]

A couple suggestions:

- add the SAP SQL Anywhere tag to your question to increase visibility

- visit https://sqlanywhere-forum.sap.com which appears to be more active than https://answers.sap.com

[chris_keating]

MobiLink is the technology that is needed to synchronize data between SQL Anywhere remotes and a variety of backends including MSSQL. Have you looked at the documentation for MobiLink. Starting here SAP SQL Anywhere | SAP Help Portal, refer to MobiLink Getting Started, MobiLink Server Administration, and MobiLink Client Administration.

There is not a specific MSSQL tutorial but review Microsoft SQL Server and Microsoft Azure Consolidated Databases | SAP Help Portal and MobiLink Tutorials | SAP Help Portal to get an overview of the technology and some MSSQL specific details. There is a tutorial for Adaptive Server Enterprise (ASE) which is similar to MSSQL (MSSQL started as a port of the ASE to the Windows platform).

All that said, the majority of the MobiLink technology is agnostic to the consolidated environment. You do write scripts to perform tasks on the consolidated database but that is really your code and typically written as SQL. In theory, to move a MobiLink solution is create the MobiLink catalog on the consolidated and rewrite the scripts, if needed, to run on the consolidated, and point the MobiLink server to connect to that new consolidated. The majority of the work resets in the scripts that are application specific that do the work to determine how and what to synchronize.