I realize this isn't answering your question but why are you using perl? You could just use an SSIS package since they are both MSSQL and you seem to easily be able to talk to both machines.
Back to the question at hand, where it the perl running (Linux/Windows)?, same machine as one of the databases?, same network (vs across VPN)? If Linux what are you using to connect to MSSQL (i.e. easysoft)? Brian On Thu, Aug 26, 2010 at 1:59 PM, Tim Bunce <tim.bu...@pobox.com> wrote: > ----- Forwarded message from Mahesh y <mahesh....@gmail.com> ----- > > Date: Thu, 26 Aug 2010 17:29:35 +0530 > From: Mahesh y <mahesh....@gmail.com> > To: tim.bu...@pobox.com > Subject: DBI Performance for SQL Server > > Hi Tim, > Hope you are doing good. I am a software programmer struggling to solve the > problems in my code. > Pls. find below the summary of my problem > 1. I am migrating data from MSSQL to MSSQL DB. > 2. I am fetching data from source DB, manipulating Data and inserting into > Target DB. > 3. Data manipulation involves some complex business logic. > Note: The SQL statements are prepared. (More than 100 tables are present) > a. Data have to be queried from TABLE X, Y and Z respectively > and the sequence will change according to business logic. > b. One row will be fetched from source and inserted to target at a time. > 4. Data model between two DBs are different. > 5. I am using Perl, DBI::ODBC to migrate the data. > 6. I can only able to transfer 100, 000 records in a period of 60 minutes. > The performance is very slow and I am struggling to overcome the problem. > Can you pls. ignite some light in my problem ? > In case of any queries, pls. revert back. > Thank you very much > Regards, > Mahesh > > ----- End forwarded message ----- >
