|
Home > Archive > SQL Anywhere database replication > November 2005 > Cheap replication?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cheap replication?
|
|
|
| I work in a hospital, and we have an application that is a
stand-alone installation on numerous PCs scattered
throughout our WAN. The application requires logging into
the app. The usernames and passwords are stored locally in
a SQL Anywhere database. So, you can see our problem. Does
anyone have any suggestions on how to replicate
usernames/passwords across the enterprise to each of these
installations of SQL Anywhere without having to resort to
Sybase Replication manager ($$$)? It should also be noted
that I know very little about Sybase, so please keep that in
mind if you reply.
Thanks!
| |
| Breck Carter [TeamSybase] 2005-11-03, 8:25 pm |
| If you are talking about user ids and passwords stored in an
*application* table, then either SQL Remote or MobiLink can be used to
replicate the information periodically.
If you are talking about the SQL Anywhere user ids and passwords
stored in SYS.SYSUSERPERM, then no such luck. However, you might be
able to build something on *top* of SYSUSERPERM, that uses a
application table for the purposes of porting this information
around... for that, MobiLink's flexibility would come in handy.
What version of SQL Anywhere are you using? SQL Remote and MobiLink
comes in the box these days... that's cheap as cheap can be :) Rep
Server is probably massive overkill.
Breck
On 3 Nov 2005 14:15:58 -0700, Kevin wrote:
>I work in a hospital, and we have an application that is a
>stand-alone installation on numerous PCs scattered
>throughout our WAN. The application requires logging into
>the app. The usernames and passwords are stored locally in
>a SQL Anywhere database. So, you can see our problem. Does
>anyone have any suggestions on how to replicate
>usernames/passwords across the enterprise to each of these
>installations of SQL Anywhere without having to resort to
>Sybase Replication manager ($$$)? It should also be noted
>that I know very little about Sybase, so please keep that in
>mind if you reply.
>
>Thanks!
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| It's SQL Anywhere 8. Not sure if it's using an application
table or the SYS.SYSUSERPERM table. If I had to guess, I'm
guessing application table. I've got an inquirey into the
vendor to find out. I'll check out SQL Remote and MobiLink.
Thanks for the info!
Oh, and another question: is their a default admin or
system username/password? I know for Oracle it's
change_on_install.
> If you are talking about user ids and passwords stored in
> an *application* table, then either SQL Remote or MobiLink
> can be used to replicate the information periodically.
>
> If you are talking about the SQL Anywhere user ids and
> passwords stored in SYS.SYSUSERPERM, then no such luck.
> However, you might be able to build something on *top* of
> SYSUSERPERM, that uses a application table for the
> purposes of porting this information around... for that,
> MobiLink's flexibility would come in handy.
>
> What version of SQL Anywhere are you using? SQL Remote and
> MobiLink comes in the box these days... that's cheap as
> cheap can be :) Rep Server is probably massive overkill.
>
> Breck
>
> On 3 Nov 2005 14:15:58 -0700, Kevin wrote:
>
> a >stand-alone installation on numerous PCs scattered
> into >the app. The usernames and passwords are stored
> locally in >a SQL Anywhere database. So, you can see our
> problem. Does >anyone have any suggestions on how to
> replicate >usernames/passwords across the enterprise to
> each of these >installations of SQL Anywhere without
> having to resort to >Sybase Replication manager ($$$)? It
> should also be noted >that I know very little about Sybase
> , so please keep that in >mind if you reply.
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Breck Carter [TeamSybase] 2005-11-04, 9:23 am |
| DBA/SQL
FWIW Version 8 has full-fledged implementations of SQL Remote and
MobiLink. However, if you got the product as part of a third-party
application, the vendor may have only licenced part of the SQL
Anywhere product for deployment. Look for these executables:
dbremote.exe - SQL Remote
dbmlsrv8.exe, dbmlsync.exe - MobiLink server and client
Breck
On 3 Nov 2005 15:25:23 -0700, Kevin wrote:
[color=darkred]
>It's SQL Anywhere 8. Not sure if it's using an application
>table or the SYS.SYSUSERPERM table. If I had to guess, I'm
>guessing application table. I've got an inquirey into the
>vendor to find out. I'll check out SQL Remote and MobiLink.
> Thanks for the info!
>
>Oh, and another question: is their a default admin or
>system username/password? I know for Oracle it's
>change_on_install.
>
>http://www.amazon.com/exec/obidos/A...7/risingroad-20
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Kevin 2005-11-04, 11:23 am |
| It appears that their's a dbremote.exe on the installation.
I'll research how to use this utility. I appreciate your
help Breck!
Thanks,
Kevin
|
|
|
|
|