Replication from SQL Anywhere to Microsoft SQL Server

[Former Member]

SQL Anywhere Community,

I have a customer who wants to replicated their Replication from SQL Anywhere to Microsoft SQL Server Data Warehouse. Are there any whitepapers on this or qualified consultants that could deliver?

Regards,

Joseph Shaffner | Vice President, SAP Solutions | Bradmark Technologies, Inc.

<Post was moderated>

[jeff_albion · Accepted solution]

Hi Joseph,

I can help with the "whitepaper" aspect of this question. All of the information for synchronizing with MobiLink can be found in the official SQL Anywhere documentation: http://dcx.sap.com/

We have tutorials for SQL Anywhere, Adaptive Server Enterprise, and Oracle available in the documentation. However, the tutorials can be easily adapted to work with Microsoft SQL Server.

I can also provide some further technical information about synchronizing to Microsoft SQL Server:

• The general tutorial for working with MobiLink in Sybase Central and with a MobiLink Synchronization Model is here:
  
  http://dcx.sap.com/index.html#sa160/en/mlstart/sqlatut.html
  
  Initially, you may want to follow it "as-is" (which uses a SQL Anywhere consolidated database) in order to get a better understanding of the MobiLink product. You can then move on to using a Microsoft SQL Server consolidated database afterwards.
  
  
• Changing the tutorial to work with a different consolidated database is mostly related to creating an ODBC DSN that targets a Microsoft SQL Server instance. You would pick that DSN when defining a consolidated database in your MobiLink synchronization model. The rest of the instructions regarding creating scripts and models is the same, but using Microsoft SQL Server SQL syntax (T-SQL) instead of SQL Anywhere syntax inside the synchronization scripts.
  
  
• You will need to install the MobiLink system tables for Microsoft SQL Server. The script to do this can be found at: %SQLANY16%\MobiLink\setup\syncmss.sql. If you are using Sybase Central to create a Synchronization Model though, once you connect to Microsoft SQL Server, you will be prompted to install the MobiLink system tables automatically (i.e. run the script).
  
  
• There are some Microsoft SQL Server specific issues that you will want to be aware of:
  http://dcx.sap.com/index.html#sa160/en/mlserver/ml-basics-mss-5159304.html

I have contacted some people internally here at SAP about consulting engagements to see if they can assist. If you are already working with an SAP Sales representative, it would probably be best to inquire with them directly and look into your available options.

Regards,

Jeff Albion

SAP Active Global Support

[Former Member · Accepted solution]

Jeff.

Thank you very much!

[former_member1317318]

None of the above links are working for me. Has the documentation moved someplace else ?

[former_member751591]

Thanks for coming to SAP Community for answers. Please post your question as a new question here:

Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members.

Please note, that your post here won't be answered.