(Fwd) DBI Performance for SQL Server

----- Forwarded message from Mahesh y <[email protected]> -----

Date: Thu, 26 Aug 2010 17:29:35 +0530
From: Mahesh y <[email protected]>
To: [email protected]
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 -----