The 'Best way' may not be Perl. Is this a one time shot, or something where the two servers need to interact constantly?
If this is one time, or something that needs to happen only periodically, I would recommend Data Transformation Services (DTS). That is part of the MS SQL installation if it is version 7.0 or higher. It is actually quite good for transferring data between any two data sources where you can connect to each either by ODBC or some OLE-DB compliant interface - neither one of them have to be MS SQL. It can be very simple, or you can put together pretty complex transformation packages that can be stored and executed periodically. I'd recommend starting out in the MS SQL Server Books Online for details on its use. Hope this helps. Steve H. -----Original Message----- From: Veera P. Nallamilli [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:53 AM To: [EMAIL PROTECTED] Subject: Copying image data from Sybase to Mssql or vice versa I am using DBD:Sybase to interact with Sybase database and using DBD:ODBC for Mssql database. I tried to copy image data either way , but unfortunately failed. Could anybody please suggest me like what is the best way to transfer the data from sybase to Mssql or vice versa. Thanks prasad
