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.

Sync data from one database to another without loosing collation

2 posts in General Discussion Last posting was on 2008-12-08 21:50:05.0Z
kshaver Posted on 2008-12-08 21:33:37.0Z
Reply-To: "kshaver" <kshaver@microkey.com>
From: "kshaver" <kshaver@microkey.com>
Newsgroups: ianywhere.public.general
Subject: Sync data from one database to another without loosing collation
Lines: 1302
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <493d92b1@forums-1-dub>
Date: 8 Dec 2008 13:33:37 -0800
X-Trace: forums-1-dub 1228772017 10.22.241.152 (8 Dec 2008 13:33:37 -0800)
X-Original-Trace: 8 Dec 2008 13:33:37 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7254
Article PK: 5473

Running Sybase version 9.0.2.3500

Explanation:
One database on network clustered between two servers. Failover occurs to
second server due to connection between two servers is broken. First server
still running and has clients connected but second server also running with
client connections. Is there a way to merge the data that was written to
the second server database into the first server database to make it one
database again when connection reestablished? Topo attached.

Any assistance would be appreciated!

Karen Shaver


Jeff Albion (Sybase iAnywhere) Posted on 2008-12-08 21:50:05.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Sync data from one database to another without loosing collation
References: <493d92b1@forums-1-dub>
In-Reply-To: <493d92b1@forums-1-dub>
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: <493d968d$1@forums-1-dub>
Date: 8 Dec 2008 13:50:05 -0800
X-Trace: forums-1-dub 1228773005 10.22.241.152 (8 Dec 2008 13:50:05 -0800)
X-Original-Trace: 8 Dec 2008 13:50:05 -0800, vip152.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7255
Article PK: 5469

Karen,

What mechanism were you using to monitor the fail-over and perform the
replication stand-by? This seems like a large problem for your H/A
system if your environment can be separated due to network issues. I'd
recommend moving to a active-passive cluster using the Microsoft
clustering service in v9 (See: http://www.sybase.com/detail?id=1034743
), or moving to version 10/11 with H/A:
http://dcx.sybase.com/1100en/dbadmin_en11/da-highavailability.html

---

Since both databases have separate data (and therefore unmatched
transaction logs), this will likely require a manual intervention to
synchronize the data again. I'd suggest trying to establish the timeline
of when the fail-over replication diverged, translate the transaction
log (dbtran) of the "offline" database you wish to apply to the "online
copy" and remove any SQL statements that you believe are already in the
online copy.

I'd try translating both transaction logs and then do a "diff" on them
to help figure out at what point they started to stray.

Regards,

kshaver wrote:

> One database on network clustered between two servers. Failover occurs to
> second server due to connection between two servers is broken. First server
> still running and has clients connected but second server also running with
> client connections. Is there a way to merge the data that was written to
> the second server database into the first server database to make it one
> database again when connection reestablished? Topo attached.

--
Jeff Albion, SQL Anywhere Engineering
Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0