July 7, 2005 at 10:59 pm
How can i transfer data from oracleDB table to sqlDB table with in seconds?
July 7, 2005 at 11:14 pm
I'd use the DTS database transfer wizard... but in seconds that might be asking a little much. How big is the oracle db?
Are they on the same server (is the network connection fast between the servers)?
Is there a lot of objects to transfer?
Now that I think of it I'm not even sure that it's possible to do a copy object operation between sql and oracle... will confirm tomorrow.
July 8, 2005 at 7:41 am
You will need to make sure you have the proper Oracle client tools on the machine you are trying to run DTS from.
And as Remi pointed out - the time depends on how much data is being transferred as well as you networks capabilities.
Good Luck,
Darrell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply