sql remote, replication server
I have a main location, where Sybase ASE and most users are sitting, and one
secondary locations connected through internet where more users access main
database with PowerBuilder applications. Of course, in the secondary
location PB applications run slow.
People in the secondary location does a lot of read from database, and few
I tried web deploy kit, but it is too slow (we need LOTS of stuff on screen,
Now I think of having two databases, that are kept synchronized by
"something" (e.g. overnight).
My question is, what should "s...Replication Server with SQL Remote
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
We are trying to configure a Replication Server Warm Standby
schema. We already have an SQL Remote replication runing in
this server. We try to use the SQL Remote open server, but
it didn' t work, we follow all the steps in the SQL Remote -
Replication Server Manual, but it don't have enought
information and we think, we are missig one step.
We are sending the log of our SQL remote open server.
Someone kn...Replication is not replicating
The new database is added to the replication system but all
tables on the RDB are empty. Setreptable is on and there's
no uncommitted transaction. It is using default action
class and there's no loss detection. Queue is caught up.
We turned on "dsi_buf_dump" and it shows on the error log
that the transaction executed on the PDB is replicated.
However, the table is again empty on the RDB. Log is not
full on both RDB and RSSD. Maint user is dbo. What else
can I take a look at? PDS and RDS is 22.214.171.124, RS is 11.0.3
I don't remember since what version warm ...Replication sql-anywhere-> Oracle without replication server?
Replication sql-anywhere-> Oracle without replication server?
Anyone got some experience to share?
Replication Server is the only way to do this.
Please post only to the news group.
Jonas Bonde wrote in message ...
>Replication sql-anywhere-> Oracle without replication server?
>Anyone got some experience to share?
We are going to be installing AS Enterprise in home office and AS Anywhere
in the field. We would like to use an autoincrement key on some tables. Is
there a good way to avoid duplicate keys. Also, are there any pitfalls to
using the two different servers for replication.
You cannot take advantage of the special IDENTITY data type when
creating a replication definition with an ASA db as the subscriber. If
you try this, replication of inserts from ASE to ASA will fail, because
the rep server will try to issue a "set identity_insert tablename on"
comman...Replicate SQL Anywhere Text column to ASE using Replication Server
Is it possible replicate text column in SQL anywhere 5.5.04 using
Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive
yes. Replication of BLOBs works fine
Manager Custom Support
Sybase Canada Inc.
virginia cheung wrote in message <01bdf3e7$6ed5c420$010414ac@star>...
>Is it possible replicate text column in SQL anywhere 5.5.04 using
>Replication Agent for SQL Anywhere and Replication Server 11.5 to Adaptive
>Server ...SQL Remote with Existing Replication Server Installation
I've been trying to run SQL Remote with RS and have not yet figured it
out. Keep getting the following error once I create a RS connection to
the SQL Remote Open Server:
E. 12/22 12:33:50. Error 2812: Stored procedure 'bogus' not found.
Specify owner.objectname or use sp_help to check whether the object
exists (sp_help may produce lots of output).
I. 12/22 12:33:50. ATTENTION handler active
E. 12/22 12:33:59. CTLIB Failure 01010110: ct_command(): user api layer:
external error: This routine cannot be called while results are pending
for a command that has been sent to t...San replication for replication server
Has anyone ever put a replication server on SAN disk with
the intention of replication the stable queues and RSSD to a
DR sire via SAN replication
In other words replicate the entire replication server
across the SAN and bring it up whe DR is invoked
would there be any datalose on teh stables queues ?
> Has anyone ever put a replication server on SAN disk with
> the intention of replication the stable queues and RSSD to a
> DR sire via SAN replication
> In other words replicate the entire replication server
> across the SAN and bring it up ...SQL remote message will hangs when replicating and hang the server.
Do you have the problem that (on ASA 704 on Window 2003.)
some SQL remote message will hangs when replicating and hang
the server. There is no error was written in the error log.
But after I delete the fisrt message from the consol and
restart the server, and resend the message from remote
database the SQL remote runs fine.
Not that we are aware of ... but I don't believe anything 7.0.x
was ever tested on W2K+3 ... but it is unlikely to be an OS
issue; especially if this if file based.
You might want to be more specific about what you mean by
a hang here; this ...Bi-directional replication with Replication Server
What are the databases that participate in bi-directional replication
with a SQL Anywhere database? I heard that you can replicate only
INTO MS SQL Server, but not out (into SQL Anyhwere).
Does the same limitation hold for Adaptive Server Enterprize (a.k.a.
Sybase SQL Server) or Oracle on NT?
Please note that we are developing for Win95/Win NT paltform only. Any
feedback is appreciated.
SQL Anywhere can participate fully and bidirectionally in a Rep Server
setup. This means that it can replicate bidirectionally with ASE on all
platforms. It can re...Replicating trigger action with SQL remote (SQL/Anywhere)
I need to replicate the actions of a trigger in one of my tables. I've
tried to use the -t option when running dbremote, but this still does not
replicate the trigger actions. Is there a solution to this problem?
I need to replicate the action of the trigger because I'm trying to do the
I need a sigle unique id for record in a table, and that table may be
inserted into at any number of remote databases, and at the consolidated
database. I've used an autoincrement column and a current publisher column
as the actual unique primary key, and have another column ...SQL Server Replication
I want to test SQL Server replication. Can I create two databases and replicate between on the same server as to give me an idea on how replication will work?Or should I use two completely seperate SQL servers to test replication?Any good links to setting up the replication?Thanks!
You don't need two servers to configure replication, the only requirement SQL Server Agent with a service account with Admin level permissions. Run a search for replication configuration and requirements in the BOL(books online). I am assuming you know it is a resource intensi...replication to SQL-Server
wei� hier jemand, ob es m�glich ist eine Replikation von Daten der Sybase
Datenbank auf einen MS SQL-Server zu replizieren? Oder noch besser hat das
schon einmal jemand gemacht?
does anybody knows if it is able to make replication from Sybase to MS
SQL-Server 7. Or better, did anybody practice this with success?
Yes, Sybase supports replication to and from MS SQLServer 7.0
Sybase has a DirectConnect for MS SQLServer product that will act as a
"Sybase" server (from a Rep Server point of view), using ODBC to communicate
to SQLServ...SQL Remote Replication
I would like to use SQL Remote Replication over a telephone modem connection
with a FILE type link. The app I am working on is being written in VB and
contains an embedded Sybase DB (i.e. Only the DB and required run time files
The manuals show a tutorial on one PC, which works fine. It also refers to a
simple file transfer mechanism that can be used to exchange files
periodically to effect replication. It doesn't say which files should be
transferred and to what directories?
Does anyone have a specific example on how this can be done?
The modem connection ...