SQL Anywhere Mobile - ASE vs ASA synch.

Author

ASE vs ASA synch.

Toni

2005-03-30, 9:43 am

Hi,

I am new to mobilink, and I am trying to setup the ASE 12.5
vs ASA 9.0.0 synch. I can't find any good documentation on
how to setup a complete synch system between ase and asa
Please correct me if I am wrong:
Create mobilink table in ASE by running synase12.5
create publication => can't use command create publication
(for asa only)
create synch user => create synch .... => same problem (asa
command does not work on ase)

......
Most of the sqlremote for ASE are using system procedures:

sp_publisher
sp_add_remote_table
sp_create_publicatio
n
sp_add_article
sp_grant_remote
sp_subscription

thanks,
Toni

Chris Keating \(iAnywhere Solutions\)

2005-03-30, 9:43 am

http://www.ianywhere.com/whitepapers/asemltut.html

<Toni> wrote in message news:4235a215.18b0.1681692777@sybase.com...
> Hi,
>
> I am new to mobilink, and I am trying to setup the ASE 12.5
> vs ASA 9.0.0 synch. I can't find any good documentation on
> how to setup a complete synch system between ase and asa
> Please correct me if I am wrong:
> Create mobilink table in ASE by running synase12.5
> create publication => can't use command create publication
> (for asa only)
> create synch user => create synch .... => same problem (asa
> command does not work on ase)
>
>
> .....
> Most of the sqlremote for ASE are using system procedures:
>
> sp_publisher
> sp_add_remote_table
> sp_create_publicatio
n
> sp_add_article
> sp_grant_remote
> sp_subscription
>
> thanks,
> Toni

toni

2005-03-30, 9:43 am

Thank Chris for the quick respond.
However, I did go over the documentation before posting my
question.
If any more information about that, please let me know.
thanks,

> http://www.ianywhere.com/whitepapers/asemltut.html
>
> <Toni> wrote in message
> procedures: >
>
>

Chris Keating \(iAnywhere Solutions\)

2005-03-30, 9:43 am

This document covers everything that you need to setup ML to run against
ASE. Perhaps you can outline the gap or the areas that are not covered?

<toni> wrote in message news:4235ad5c.1a13.1681692777@sybase.com...[color=darkred]
> Thank Chris for the quick respond.
> However, I did go over the documentation before posting my
> question.
> If any more information about that, please let me know.
> thanks,
>
>

Greg Fenton

2005-03-30, 9:43 am

Toni wrote:
> Please correct me if I am wrong:

You are wrong :-)

> Create mobilink table in ASE by running synase12.5

yes.

> create publication => can't use command create publication
> (for asa only)
> create synch user => create synch .... => same problem (asa
> command does not work on ase)

No, you only create publications and synch users in the *remote*
databases. ASE can only be used as a *consolidated* database.

The document Chris pointed you to does not have you use any of these
commands against the ASE database, does it?

> Most of the sqlremote for ASE are using system procedures:
>

SQL Remote and MobiLink are two very different approaches to data
movement. Though *some* of the concepts are similar, for the most part
you need to separate your knowledge of the inner workings of replication
(SQL Remote) when you move to synchronization (MobiLink).

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links