Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
Steve
Does Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
SteveDoes Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
Steve
Does Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bi-Directional Transactional Replication - Problem

Two Servers,
1st 2nd
database a --> after replication a'
b' <-- after replication b
on 1st server a is replicated to 2nd
on 2nd server b is replicated to 1st
I tried with merge replication it is working fine.But if i tried to use
transactional replication it give some error like "access
violation".Using tansactional replication is it possible.plz help me to
slove this problem.
Regards,
Senthil prabu R
When you used sp_addsubscription, did you set @.loopback_detection=true?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"senthilprabu" <senthilpraburaju@.gmail.com> wrote in message
news:1125116841.951132.162370@.o13g2000cwo.googlegr oups.com...
> Two Servers,
> 1st 2nd
> database a --> after replication a'
> b' <-- after replication b
> on 1st server a is replicated to 2nd
> on 2nd server b is replicated to 1st
> I tried with merge replication it is working fine.But if i tried to use
> transactional replication it give some error like "access
> violation".Using tansactional replication is it possible.plz help me to
> slove this problem.
> Regards,
> Senthil prabu R
>

Bi-directional Transaction Replication

Two Servers,

1st 2nd
database a ---> after replication a'
b' <--- after replication b

on 1st server a is replicated to 2nd
on 2nd server b is replicated to 1st

I tried with merge replication it is working fine.But if i tried to use
transactional replication it give some error like "access
violation".Using tansactional replication is it possible.plz help me to
slove this problem.

Regards,
Senthil prabu RI have no idea myself, but under "Nonpartitioned, Bidirectional,
Transactional Replication", Books Online says that to implement
bidirectional transactional replication "substantial customization and
programming is usually required."

So you might get a better response in
microsoft.public.sqlserver.replication, as it seems to be something
quite specialized.

Simon

Best way to copy a replicated database?

I need to copy an installation to another server without breaking merge
replication on the existing database. Is the best approach to simply script
out the database, do an export of the data, then recreate on the other end
and set up a new publication?
Earl,
if it is the publisher or the subscriber, as long as the machine name is
different in practice you'll need to reinitialize. You caould do a nsync
one, provided you could ensure the data is synchronized. This can be
achieved by stopping all activity during the process, or by using
datacompare after the restore. After that, you'll need to recreate the
publication (if publisher) and initialize.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul. These are PocketPCs, so it sounds like the goal should be to
gather up one last round of data, then create a new database, load the data,
then create a new publication and initialize?
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:untCSjg2FHA.2492@.TK2MSFTNGP09.phx.gbl...
> Earl,
> if it is the publisher or the subscriber, as long as the machine name is
> different in practice you'll need to reinitialize. You caould do a nsync
> one, provided you could ensure the data is synchronized. This can be
> achieved by stopping all activity during the process, or by using
> datacompare after the restore. After that, you'll need to recreate the
> publication (if publisher) and initialize.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Earl,
that sounds like a pretty clean way of doing it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Best way to Copy a Replicated Database?

Hi.
We have a production database that is set up to be replicated to a fail-over
server, with two-day synchronization.
Periodically, our developers would like to make copies of the production
database to their development box. Obviously, we would just like to take a
copy of the database, without any of the replication settings. However, the
Copy Database Wizard does not allow copying of replicated databases.
How would you approach this problem?
Thanks
Jon,
you could use backup and restore.
HTH,
Paul Ibison
|||Hi. Thanks.
This will work to some extent. But I was hoping for something like Copy
Database Wizard, because of all other dependent information it can copy at
the same time.
Do I need to look for and copy anything manually after backup/restore to a
different server?
"Paul Ibison" wrote:

> Jon,
> you could use backup and restore.
> HTH,
> Paul Ibison
>
>
|||Jon,
essentially they do the same thing, however the way they do it is different.
The Copy database wizard does a detach and attach (sp_detach_db and
sp_attach_db) which causes your problems. Backup and restore will not cause
such problems but will achieve the same aims.
HTH,
Paul Ibison
|||Thank you very much. It worked just fine: it copied all relevant users and
Full-Text Catalog settings as well, which was pretty handy. I suppose the
only thing that did not get copied were the replication settings and some
jobs, which we mostly did not want copied to our development instance, anyhow.
"Paul Ibison" wrote:

> Jon,
> essentially they do the same thing, however the way they do it is different.
> The Copy database wizard does a detach and attach (sp_detach_db and
> sp_attach_db) which causes your problems. Backup and restore will not cause
> such problems but will achieve the same aims.
> HTH,
> Paul Ibison
>
>