[freetds] named pipe as a host file for freebcp

Constantin Vasilyev vasilyev at ncbi.nlm.nih.gov
Wed Jan 3 10:46:53 EST 2007


It seems like datacopy utility doesn't copy image fields well.

Here's my setup:

use testdb
go
create table Blob1(id int primary key, data image null)
create table Blob2(id int primary key, data image null)
insert Blob1 select 1, 0x1234567890abcdef
go

I tried to copy the data (single row) from Blob1 into Blob2.
datacopy utility built as part of 0.64 stable didn't work at all:

.../datacopy -SMSSQL0/anyone/allowed/testdb/Blob1 
-DMSSQL0/anyone/allowed/testdb/Blob2 -t
Error in dbnumcols
datacopy: table structures do not match. terminating


And one built out of latest CVS source worked with no errors but didn't 
copy image data:

 > ./datacopy -SMSSQL0/anyone/allowed/testdb/Blob1 
-DMSSQL0/anyone/allowed/testdb/Blob2 -t
 > sqsh-ms -S MSSQL0 -D testdb
[101] MSSQL0.testdb.1> select * from Blob2; -mvert
id:   1
data: NULL

[102] MSSQL0.testdb.1> select * from Blob1; -mvert
id:   1
data: 0x1234567890abcdef

Constantin

Thompson, Bill D (London) wrote:
> Hi Constantin,
> 
> If you want to copy data in bulk from one server to another, you can try
> using the "datacopy" executable we have in freeTDS.
> It was designed to do this job. 
> 
> Bill
> 
> -----Original Message-----
> From: freetds-bounces at lists.ibiblio.org
> [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Constantin
> Vasilyev
> Sent: 22 December 2006 15:20
> To: freetds at lists.ibiblio.org
> Subject: [freetds] named pipe as a host file for freebcp
> 
> 
> Hi,
> 
> Native Sybase bcp allows using of named pipe as a host file for "bcp
> in".
> It is extremely useful for coping large tables from one server to
> another
> because virtually no disk space is required this way.
> I wonder how hard would it be to implement that in freetds bcp?
> 
> Thanks,
> Constantin Vasilyev
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> --------------------------------------------------------
> 
> If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


More information about the FreeTDS mailing list