Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How we can copy table from network server

4 posts in General Discussion Last posting was on 2004-02-13 21:28:13.0Z
Chandresh Patel Posted on 2004-02-12 20:14:26.0Z
Sender: 5dee.402bde45.1804289383@sybase.com
From: Chandresh Patel
Newsgroups: ianywhere.public.general
Subject: How we can copy table from network server
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <402bdea2.5def.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Feb 2004 12:14:26 -0800
X-Trace: forums-1-dub 1076616866 10.22.241.41 (12 Feb 2004 12:14:26 -0800)
X-Original-Trace: 12 Feb 2004 12:14:26 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2475
Article PK: 5613

HI,

Is there any way to copy whole table from network server to
locally or sql light table.

Thanks in advance


Robert Waywell Posted on 2004-02-13 15:12:02.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <402bdea2.5def.846930886@sybase.com>
Subject: Re: How we can copy table from network server
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <402ce942$1@forums-1-dub>
Date: 13 Feb 2004 07:12:02 -0800
X-Trace: forums-1-dub 1076685122 172.31.142.236 (13 Feb 2004 07:12:02 -0800)
X-Original-Trace: 13 Feb 2004 07:12:02 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2482
Article PK: 5620

Certainly you can retrieve data from a network database server and store it
in another file. Your options for this depend entirely on what you want to
do with it. Some possibilities are:

1) UNLOAD TABLE specifying a UNC path to the desired location
2) Spawning DBISQL from the client and using the OUTPUT statement
3) A cursor to retrieve records and then whatever code you feel appropriate
to manipulate the data on the client side
4) (Haven't seen this in awhile) The DataPipeline tool from Infomaker, which
is part of SQL Anywhere Studio

So, what are you trying to accomplish?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Chandresh Patel> wrote in message
news:402bdea2.5def.846930886@sybase.com...
> HI,
>
> Is there any way to copy whole table from network server to
> locally or sql light table.
>
> Thanks in advance


Scott Kruer Posted on 2004-02-13 15:35:22.0Z
From: Scott Kruer <No_Spam-skruer@ianywhere.com>
Newsgroups: ianywhere.public.general
Subject: Re: How we can copy table from network server
Organization: iAnywhere Solutions
Reply-To: No_Spam-skruer@ianywhere.com
Message-ID: <o3qp20l3nng4rj9bsarin097lruu1aac3m@4ax.com>
References: <402bdea2.5def.846930886@sybase.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: c-24-129-210-149.se.client2.attbi.com
X-Original-Trace: 13 Feb 2004 07:46:25 -0800, c-24-129-210-149.se.client2.attbi.com
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Feb 2004 07:17:12 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Feb 2004 07:35:22 -0800
X-Trace: forums-1-dub 1076686522 10.22.108.75 (13 Feb 2004 07:35:22 -0800)
X-Original-Trace: 13 Feb 2004 07:35:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2484
Article PK: 5621

Are you copying the data from the network table to a local table or a
local file as Robert has assumed? If you are asking can a table from a
network server be 'replicated or synchronized' to a local table, the
answer is yes.

If it is a 'one time' thing, then Rob's UNLOAD TABLE on the network
database table suggestion followed by reloading the sql file into the
local database table would be the simplest.

If you are asking for a continuous solution, take a look at MobiLink
in the SQL Anywhere Studio documentation.

HTH....

On 12 Feb 2004 12:14:26 -0800, Chandresh Patel wrote:

>HI,
>
>Is there any way to copy whole table from network server to
>locally or sql light table.
>
>Thanks in advance


Chandresh Patel Posted on 2004-02-13 21:28:13.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <402bdea2.5def.846930886@sybase.com> <o3qp20l3nng4rj9bsarin097lruu1aac3m@4ax.com>
Subject: Re: How we can copy table from network server
Lines: 48
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: acac95fd.ipt.aol.com
X-Original-NNTP-Posting-Host: acac95fd.ipt.aol.com
Message-ID: <402d416d@forums-1-dub>
Date: 13 Feb 2004 13:28:13 -0800
X-Trace: forums-1-dub 1076707693 172.172.149.253 (13 Feb 2004 13:28:13 -0800)
X-Original-Trace: 13 Feb 2004 13:28:13 -0800, acac95fd.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2497
Article PK: 5636

Hi,

You are right but my question is this....

I have one report in c# and that required so many query to pass to server
(almost 500 times) and each time it takes some time and after all it takes 3
to 6 minutes.

Now if i select whole in AsaDataReader then it takes 1 second but I don't
know how to process this datareader in c# or how to pass SQL in to it.

Second Question:
============
If i hava local table and how can i download few table from my server.

"Scott Kruer" <No_Spam-skruer@ianywhere.com> wrote in message
news:o3qp20l3nng4rj9bsarin097lruu1aac3m@4ax.com...
> Are you copying the data from the network table to a local table or a
> local file as Robert has assumed? If you are asking can a table from a
> network server be 'replicated or synchronized' to a local table, the
> answer is yes.
>
> If it is a 'one time' thing, then Rob's UNLOAD TABLE on the network
> database table suggestion followed by reloading the sql file into the
> local database table would be the simplest.
>
> If you are asking for a continuous solution, take a look at MobiLink
> in the SQL Anywhere Studio documentation.
>
> HTH....
>
> On 12 Feb 2004 12:14:26 -0800, Chandresh Patel wrote:
>
> >HI,
> >
> >Is there any way to copy whole table from network server to
> >locally or sql light table.
> >
> >Thanks in advance
>