Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Synchronization/Replication with Tables in MS SQL Server

7 posts in General Discussion Last posting was on 2010-02-24 08:56:42.0Z
Glenn Barber Posted on 2010-02-21 20:10:08.0Z
Sender: 7443.4b818f63.1804289383@sybase.com
From: Glenn Barber
Newsgroups: ianywhere.public.general
Subject: Synchronization/Replication with Tables in MS SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b819320.74e0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 21 Feb 2010 12:10:08 -0800
X-Trace: forums-1-dub 1266783008 10.22.241.41 (21 Feb 2010 12:10:08 -0800)
X-Original-Trace: 21 Feb 2010 12:10:08 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7911
Article PK: 6940

I have a requirement to synchronize some tables in a SQL
Anywhere Database with a M/S SQL Server 2005 database. The
changes will be driven from the MS SQL Server database.

What tools or features of SQL Anywhere Version 11 could I
use to help facilitate this?

Where do I start?

Thanks for any suggestions or experience you which to share.

Glenn


Josh Savill [Sybase] Posted on 2010-02-22 14:41:32.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
References: <4b819320.74e0.1681692777@sybase.com>
In-Reply-To: <4b819320.74e0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b82979c$1@forums-1-dub>
Date: 22 Feb 2010 06:41:32 -0800
X-Trace: forums-1-dub 1266849692 10.22.241.152 (22 Feb 2010 06:41:32 -0800)
X-Original-Trace: 22 Feb 2010 06:41:32 -0800, vip152.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7913
Article PK: 6939

Glenn,

To synchronize MS SQL Server 2005 you will use MobiLink.

This is the Mobilizing Microsoft SQL Server Resource Kit: http://www.sybase.com/detail?id=1064656

This Resource Kit is the best place to start.

Here's a good place to start in the documentation:
http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-basics.html

This tutorial might be helpful: http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-contact.htm

--
Joshua Savill
Sybase Inc. - Product Manager

Glenn Barber wrote:
> I have a requirement to synchronize some tables in a SQL
> Anywhere Database with a M/S SQL Server 2005 database. The
> changes will be driven from the MS SQL Server database.
>
> What tools or features of SQL Anywhere Version 11 could I
> use to help facilitate this?
>
> Where do I start?
>
> Thanks for any suggestions or experience you which to share.
>
> Glenn


Glenn Barber Posted on 2010-02-23 06:45:30.0Z
Sender: 4232.4b837614.1804289383@sybase.com
From: Glenn Barber
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b83798a.42af.1681692777@sybase.com>
References: <4b82979c$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Feb 2010 22:45:30 -0800
X-Trace: forums-1-dub 1266907530 10.22.241.41 (22 Feb 2010 22:45:30 -0800)
X-Original-Trace: 22 Feb 2010 22:45:30 -0800, 10.22.241.41
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7920
Article PK: 6947

Thanks Joshua

It occurred to me that if the MS SQL Server Database is
always available via a DSN - I could create proxies and
access the data directly in the MS SQL Server database
rather than replicating the tables in the SA database - or
would there be some advantage to synchronize with the
specific tables using Mobiink?

Glenn

> Glenn,
>
> To synchronize MS SQL Server 2005 you will use MobiLink.
>
> This is the Mobilizing Microsoft SQL Server Resource Kit:
> http://www.sybase.com/detail?id=1064656
>
> This Resource Kit is the best place to start.
>
> Here's a good place to start in the documentation:
>
http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-basics.html
>
> This tutorial might be helpful:
>
http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-contact.htm
>
> --
> Joshua Savill
> Sybase Inc. - Product Manager
>
>
> Glenn Barber wrote:
> > I have a requirement to synchronize some tables in a SQL
> > Anywhere Database with a M/S SQL Server 2005 database.
> > The changes will be driven from the MS SQL Server
> > database.
> > What tools or features of SQL Anywhere Version 11 could
> > I use to help facilitate this?
> >
> > Where do I start?
> >
> > Thanks for any suggestions or experience you which to
> > share.
> > Glenn


Volker Barth <No_VBarth Posted on 2010-02-23 08:37:00.0Z
From: Volker Barth <No_VBarth@Spam_GLOBAL-FINANZ.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
References: <4b82979c$1@forums-1-dub> <4b83798a.42af.1681692777@sybase.com>
In-Reply-To: <4b83798a.42af.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b8393ac@forums-1-dub>
Date: 23 Feb 2010 00:37:00 -0800
X-Trace: forums-1-dub 1266914220 10.22.241.152 (23 Feb 2010 00:37:00 -0800)
X-Original-Trace: 23 Feb 2010 00:37:00 -0800, vip152.sybase.com
Lines: 59
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7921
Article PK: 6950

Glenn,

when proxy tables are "enough" in terms of availability and performance,
I would prefer them - they are much easier to setup and use.
Are you going to insert/update/delete from the SA side, too, or do you
treat the MS SQL data as "readonly" from the SA side?

HTH
Volker

Glenn Barber wrote:
> Thanks Joshua
>
> It occurred to me that if the MS SQL Server Database is
> always available via a DSN - I could create proxies and
> access the data directly in the MS SQL Server database
> rather than replicating the tables in the SA database - or
> would there be some advantage to synchronize with the
> specific tables using Mobiink?
>
> Glenn
>
>
>> Glenn,
>>
>> To synchronize MS SQL Server 2005 you will use MobiLink.
>>
>> This is the Mobilizing Microsoft SQL Server Resource Kit:
>> http://www.sybase.com/detail?id=1064656
>>
>> This Resource Kit is the best place to start.
>>
>> Here's a good place to start in the documentation:
>>
> http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-basics.html
>>
>> This tutorial might be helpful:
>>
> http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-contact.htm
>>
>> --
>> Joshua Savill
>> Sybase Inc. - Product Manager
>>
>>
>> Glenn Barber wrote:
>>> I have a requirement to synchronize some tables in a SQL
>>> Anywhere Database with a M/S SQL Server 2005 database.
>>> The changes will be driven from the MS SQL Server
>>> database.
>>> What tools or features of SQL Anywhere Version 11 could
>>> I use to help facilitate this?
>>>
>>> Where do I start?
>>>
>>> Thanks for any suggestions or experience you which to
>>> share.
>>> Glenn


Glenn Barber Posted on 2010-02-23 21:09:39.0Z
Sender: 5f8f.4b8442c3.1804289383@sybase.com
From: Glenn Barber
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b844413.5ff8.1681692777@sybase.com>
References: <4b8393ac@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Feb 2010 13:09:39 -0800
X-Trace: forums-1-dub 1266959379 10.22.241.41 (23 Feb 2010 13:09:39 -0800)
X-Original-Trace: 23 Feb 2010 13:09:39 -0800, 10.22.241.41
Lines: 72
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7932
Article PK: 6960

Right now the need is read only - and the consensus I have
had when talking to others is that proxies is the way to go
unless connection to the remote database is inconsistent or
the dataset is large enough that regular re-population of
the "replicated" tables is inpractical.

> Glenn,
>
> when proxy tables are "enough" in terms of availability
> and performance, I would prefer them - they are much
> easier to setup and use. Are you going to
> insert/update/delete from the SA side, too, or do you
> treat the MS SQL data as "readonly" from the SA side?
>
> HTH
> Volker
>
>
> Glenn Barber wrote:
> > Thanks Joshua
> >
> > It occurred to me that if the MS SQL Server Database is
> > always available via a DSN - I could create proxies and
> > access the data directly in the MS SQL Server database
> > rather than replicating the tables in the SA database -
> > or would there be some advantage to synchronize with
> > the specific tables using Mobiink?
> >
> > Glenn
> >
> >
> >> Glenn,
> >>
> >> To synchronize MS SQL Server 2005 you will use
> MobiLink. >>
> >> This is the Mobilizing Microsoft SQL Server Resource
> Kit: >> http://www.sybase.com/detail?id=1064656
> >>
> >> This Resource Kit is the best place to start.
> >>
> >> Here's a good place to start in the documentation:
> >>
> >
>
http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-basics.html
> >>
> >> This tutorial might be helpful:
> >>
> >
>
http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-contact.htm
> >>
> >> --
> >> Joshua Savill
> >> Sybase Inc. - Product Manager
> >>
> >>
> >> Glenn Barber wrote:
> >>> I have a requirement to synchronize some tables in a
> SQL >>> Anywhere Database with a M/S SQL Server 2005
> database. >>> The changes will be driven from the MS SQL
> Server >>> database.
> >>> What tools or features of SQL Anywhere Version 11
> could >>> I use to help facilitate this?
> >>>
> >>> Where do I start?
> >>>
> >>> Thanks for any suggestions or experience you which to
> >>> share.
> >>> Glenn


Josh Savill [Sybase] Posted on 2010-02-23 19:24:03.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
References: <4b82979c$1@forums-1-dub> <4b83798a.42af.1681692777@sybase.com>
In-Reply-To: <4b83798a.42af.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b842b53@forums-1-dub>
Date: 23 Feb 2010 11:24:03 -0800
X-Trace: forums-1-dub 1266953043 10.22.241.152 (23 Feb 2010 11:24:03 -0800)
X-Original-Trace: 23 Feb 2010 11:24:03 -0800, vip152.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7931
Article PK: 6959

Both have their benefits. What are you trying to accomplish? Also see Volker's comments.

--
Joshua Savill
Sybase Inc. - Product Manager

Glenn Barber wrote:
> Thanks Joshua
>
> It occurred to me that if the MS SQL Server Database is
> always available via a DSN - I could create proxies and
> access the data directly in the MS SQL Server database
> rather than replicating the tables in the SA database - or
> would there be some advantage to synchronize with the
> specific tables using Mobiink?
>
> Glenn
>
>
>> Glenn,
>>
>> To synchronize MS SQL Server 2005 you will use MobiLink.
>>
>> This is the Mobilizing Microsoft SQL Server Resource Kit:
>> http://www.sybase.com/detail?id=1064656
>>
>> This Resource Kit is the best place to start.
>>
>> Here's a good place to start in the documentation:
>>
> http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-basics.html
>> This tutorial might be helpful:
>>
> http://dcx.sybase.com/index.html#1101en/mlstart_en11/ml-contact.htm
>> --
>> Joshua Savill
>> Sybase Inc. - Product Manager
>>
>>
>> Glenn Barber wrote:
>>> I have a requirement to synchronize some tables in a SQL
>>> Anywhere Database with a M/S SQL Server 2005 database.
>>> The changes will be driven from the MS SQL Server
>>> database.
>>> What tools or features of SQL Anywhere Version 11 could
>>> I use to help facilitate this?
>>>
>>> Where do I start?
>>>
>>> Thanks for any suggestions or experience you which to
>>> share.
>>> Glenn


Breck Carter [TeamSybase] Posted on 2010-02-24 08:56:42.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Synchronization/Replication with Tables in MS SQL Server
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <vaq9o591ottkj3hmm4clqsiobu8v5ppehb@4ax.com>
References: <4b819320.74e0.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 24 Feb 2010 00:56:42 -0800
X-Trace: forums-1-dub 1267001802 10.22.241.152 (24 Feb 2010 00:56:42 -0800)
X-Original-Trace: 24 Feb 2010 00:56:42 -0800, vip152.sybase.com
Lines: 31
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7937
Article PK: 6965

In addition to the comments from Volker and Josh... the performance of
proxy tables has been vastly improved in SQL Anywhere version 12,
currently in beta. This means proxy tables have a bright future.

http://sqlanywhere.blogspot.com/2010/01/omigosh-proxy-tables-are-fast.html

Breck

On 21 Feb 2010 12:10:08 -0800, Glenn Barber wrote:

>I have a requirement to synchronize some tables in a SQL
>Anywhere Database with a M/S SQL Server 2005 database. The
>changes will be driven from the MS SQL Server database.
>
>What tools or features of SQL Anywhere Version 11 could I
>use to help facilitate this?
>
>Where do I start?
>
>Thanks for any suggestions or experience you which to share.
>
>Glenn

--
Breck Carter - Blog: http://sqlanywhere.blogspot.com/

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail