SQL Anywhere database replication

Author

File Message Type

Baruu

2005-03-30, 9:41 am

Hello,

I have one question , if I am using File Message Type how
consoldiated and remote Database will communicate, what kind
of file sharing should be there betweeb Server and Stand
Alone Laptop or different server ???

And another can we use the dbxtract utility like this
\\machine_name\c_dri
ve\tutorial\hq to extract database on
other machine rather then on which we are working.

regards,
Barru

Breck Carter [TeamSybase]

2005-03-30, 9:41 am

It is completely up to you how to pass the files between machines. And
yes, if you can "see" the drives via \\ UNC paths then there is no
need to copy or move files at all.

FTP is a popular alternative to FILE if UNC paths don't work.

Breck

On 30 Mar 2005 07:13:50 -0800, Baruu wrote:

>Hello,
>
>I have one question , if I am using File Message Type how
>consoldiated and remote Database will communicate, what kind
>of file sharing should be there betweeb Server and Stand
>Alone Laptop or different server ???
>
>
>And another can we use the dbxtract utility like this
> \\machine_name\c_dri
ve\tutorial\hq to extract database on
>other machine rather then on which we are working.
>
>regards,
>Barru

--
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

baruu

2005-03-30, 7:04 pm

This answer that you have given me is for file sharing
system??
and can you explain me what is this
>And yes, if you can "see" the drives via \\ UNC
> paths then there is no need to copy or move files at
all???

I didn't understand that?

Please explain this
Regards

> It is completely up to you how to pass the files between
> machines. And yes, if you can "see" the drives via \\ UNC
> paths then there is no need to copy or move files at all.
>
> FTP is a popular alternative to FILE if UNC paths don't
> work.
>
> Breck
>
>
> On 30 Mar 2005 07:13:50 -0800, Baruu wrote:
>
> kind >of file sharing should be there betweeb Server and
> Stand >Alone Laptop or different server ???
>
> --
> 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-03-30, 7:04 pm

You can't always use \\machinename-style paths, it depends on how your
network is set up. If you *can* use them, then go ahead.

On 30 Mar 2005 11:56:40 -0800, baruu wrote:
[color=darkred]
>This answer that you have given me is for file sharing
>system??
>and can you explain me what is this
>all???
>
>I didn't understand that?
>
>Please explain this
>Regards
>
>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

Baruu

2005-03-31, 7:01 am

Yes I cannot extract like this then how can I extract the
data on other machine.
And how this Database will communicate,
what kind of file sharing should be there between
Server and Stand Alone Laptop or different server.

And if the data already exist on two machine how they can be
synchornized.

Please clear my confusion.
Regards

> You can't always use \\machinename-style paths, it depends
> on how your network is set up. If you *can* use them, then
> go ahead.
>
> On 30 Mar 2005 11:56:40 -0800, baruu wrote:
>
> between >> machines. And yes, if you can "see" the drives
> via \\ UNC >> paths then there is no need to copy or move
> files at all. >>
> how >> >consoldiated and remote Database will communicate,
> what >> kind >of file sharing should be there betweeb
> Server and >> Stand >Alone Laptop or different server ???
> on >> >other machine rather then on which we are working.
> oad-20 >> bcarter@risingroad.com
> Services >> www.risingroad.com
>
> --
> 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

Reg Domaratzki \(iAnywhere Solutions\)

2005-03-31, 8:02 pm

If the consolidated database is running as a server (i.e. using dbsrv9, not
dbeng9), then you can run dbxtract from the other computer and connect to
the server to do your extract. For example, if you start the consolidated
database on a machine called "cons-pc" with the following command line :

dbsrv9 -x tcpip -n cons c:\db\cons.db

Then you can run dbxtract from the client machine with the following command
line to automatically create the remote database for you :

dbxtract -c
" eng=cons;dbn=cons;ui
d=dba;pwd=sql;links=
tcpip(host=cons-pc)" -an
c:\db\rem1.db rem1

You may want to read over the sample SQL I posted to the recent thread
entitled "Synchronize" to explain how to define and set up a FILE based
messaging system.

--
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

<Baruu> wrote in message news:424ba573.6720.1681692777@sybase.com...[color=darkred]
> Yes I cannot extract like this then how can I extract the
> data on other machine.
> And how this Database will communicate,
> what kind of file sharing should be there between
> Server and Stand Alone Laptop or different server.
>
> And if the data already exist on two machine how they can be
> synchornized.
>
> Please clear my confusion.
> Regards
>
> http://www.amazon.com/exec/obidos/A...7/risingroad-20

baruu

2005-04-01, 8:02 pm

I did not understand what you are trying to explain,I tried
this method on command line but it does not work.

I have one more question If We want to use FTP File Message
System what we require for that.

How to configure it without using dbextract policy.

thanks

> If the consolidated database is running as a server (i.e.
> using dbsrv9, not dbeng9), then you can run dbxtract from
> the other computer and connect to the server to do your
> extract. For example, if you start the consolidated
> database on a machine called "cons-pc" with the following
> command line :
>
> dbsrv9 -x tcpip -n cons c:\db\cons.db
>
> Then you can run dbxtract from the client machine with the
> following command line to automatically create the remote
> database for you :
>
> dbxtract -c
> " eng=cons;dbn=cons;ui
d=dba;pwd=sql
> ;links=tcpip(host=co
ns-pc)" -an c:\db\rem1.db rem1
>
> You may want to read over the sample SQL I posted to the
> recent thread entitled "Synchronize" to explain how to
> define and set up a FILE based messaging system.
>
> --
> 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
>
> <Baruu> wrote in message
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
>
>

Reg Domaratzki \(iAnywhere Solutions\)

2005-04-01, 8:02 pm

"Does not work" doesn't give me much to go on. What error was returned when
you ran the command?

Please see the following section of the documention for information on using
the FTP messaging system :

SQL Remote User's Guide
SQL Remote Administration
Using message types
The ftp message system

--
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

<baruu> wrote in message news:424d60c0.1508.1681692777@sybase.com...[color=darkred]
> I did not understand what you are trying to explain,I tried
> this method on command line but it does not work.
>
> I have one more question If We want to use FTP File Message
> System what we require for that.
>
> How to configure it without using dbextract policy.
>
> thanks
>
> http://www.amazon.com/exec/obidos/A...7/risingroad-20

Sponsored Links