Newbie SQL Srvr11 NT to Sql any W95

Newbie SQL Srvr11 NT to Sql any W95

Post by Jim Zellme » Wed, 17 Sep 1997 04:00:00

I'm looking for a faq or documentation that walks me through the steps
to "replicate" a System 11 db on NT 4.0 to SQL Anywhere on W95 laptops.
I checked Sybase's www site and only found a course for $900.  Any book
or online resources out there?




Newbie SQL Srvr11 NT to Sql any W95

Post by Tom Iaruss » Wed, 17 Sep 1997 04:00:00

Our setup is nearly identical to yours, except right now we run our SQL
Anywhere server on NT3.51.

We run Replication Server along with SQL Server under UNIX.  The rep
server is the gateway into and out of SQL Server.  It is quite
complicated.  One book I know of on the subject is SYBASE Replication
Server Primer by Charles B. Clifford.  

On you NT machine, you'll need to run SQL Anywhere Server ( version
5.5.02 at least to clean up old bugs ).  The Open Server Gateway is
included as part of the SQL Anywhere Server package.  OSG is the gateway
for changes replicating into SQL Anywhere.  Sold separately is SQL
Anywhere Replication Agent, also referred to as the Log Transfer
Manager.  This component reads the database log and sends changes to the
rep server.

The Win95 clients communicate with the SQL Anywhere Server via DBREMOTE,
also included with SQL Anywhere. This process is pretty well documented
in the SQL Anywhere doc set.

In the latest version of SQL Anywhere (5.5.03) there are numerous
referrences made to a rep agent for UNIX.  I have not yet been able to
confirm this, but it appears that this rep agent may allow you to
communicate directly from SQL Server to the Win95 client, removing the
rep server and SQL Anywhere Server.  If you need the rep server for
other replication paths however, this won't be an option because rep
server and the rep agent can't share the same database log.

Hope this helped.


1. SQL7 on W95 help for newbie

Advice to an SQL newbie please?

I run a searchable web database using Access 97/ Cold Fusion hosted
remotely on my ISP's NT server.  I've been getting regular database
corruptions and I've been advised to change to SQL.

I want to run the SQL database on my W95 desktop at home, then upload
this twice weekly to the online site.  

A couple questions:

Will I get problems with SQL on W95 fitting in with SQL running on NT?

Is SQL7.0 the same as SQL EM ? Is this what I should buy? (US$1500 here
in the UK!)

Many thanks
John Hoare
John Hoare

2. Class DAO Controls

3. Newbie : necessary memory to run Windows NT and SQL server

4. ADO Newbie problem

5. upgrade NT 3.51 with sql 6.0 to NT 4.0 with sql server 6.5

6. OLE DB problem with SQL Agent job execution

7. SQL Service doesn't start - NT Security - Newbie question

8. dBase IV - Missing Records - HELP

9. ora8 varchar2 --ODBC--> W95/NT VB5 DAO

10. CL - W95 or NT ?

11. Access to Interbase database on NT Server from W95 Stations

12. W95 vs NT Query speed

13. Problem with EXEs stored as OLE Objects in A97 on W95/NT