Hi,

I have created publisher,remote user and message agent at
consolidated database, and also given subscription to remote
user!
Now I have to create publisher,message agent and
consolidated user at remote site, but how it is related to
source database!
And how the "file sharing system" used for
File Message type

Have you been through the Tutorial? It does a pretty good job of explaining
how everything works together.

SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users


You should also have a look at the reload.sql that is generated by dbxtract
to figure out how the publisher/remote user/address information is created
on the remote based on information in the consolidated.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<sumi> wrote

Thanks for this!

But I have already gone through this tutorial! There it is
very clear
using "Extract Utility", but I think if two database already
exist on
two machine or server then we cannot use this utility then
for that how we have to do, and for that I have these
confusions which I have mentioned!


so can you please explain me all these

You can absolutely use the dbxtract utility if the databases will reside on
two machines. Instead of specifying "c:\tutorial\hq" and
"c:\tutorial\field" as the addresses for messages for each side, specify
\\machine_name\c_drive\tutorial\hq and \\machine_name\c_drive_tutorial\field
as the two addresses. Now, when you extract the remote database, copy the
database and transaction log over to the machine where the database will
eventually run. When you run dbremote, it will look for and place messages
on the network share instead of locally. Obviously, you'll eventually end
up using directories other than the ones I've specified above, but I was
trying to extend the tutorial with my example.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<sumi> wrote

Thanks for this!

but I have one confusion that:

'Now, when you extract the remote database, copy the
database and transaction log over to the machine where the
database will eventually run. "


When I extract the whole database on other machine
then the whole database is extracted then why there is need
of
" copy the database " ?

and what about the "transcation log" ?

And what do you mean by this

"where the database will eventually run." ?


you specified

"When you run
one more thing what should I give adress of publisher on
local machine then how they will communicate?



on consolidated or remote?