Hi all ,

There are two solutions found for my problem,

1) Take the data as xml input and inserting at a time.

25 lacs of data is getting inserted within 30 minutes...

Hi Lutz,

your advice seems to be more suitable for my scenario.

Thank you.

Mujeeb

Thanks you all, for your valuable suggestions. i am concluding that with sql server we will be slower than Oracle,And we cant do much modifications with sql server settings....

I am sorry for not putting my expectations.

We are doing same process of inserting in oracle in 1 hour 20 min.

we need to get in same time or reach nearer...

yes, this is one time process. I will try your advice and get back to you

I checked with java developers, its difficult for them to modify the code in short time. as we are at the verge of release.

Any thing need to be done at...

Thank you, I follow your suggestions and inputs and hope you don't mind if I ping you in case if I struck.:)

Thanks for clarification Steve. Another fast question for you.

I have set up sqlserver one way replication completely through UI only as per steps mentioned in msdn. In Oracle, I setup...

Hi Steve,

Thanks for your intime reply. I have followed transactional replicaton of sqlserver for one way replication. which worked for me similar to oracle streams one way replication. I...