sql server 2005 to oracle

[timscronin]

Anyone had any luck with 3rd party vendors going from sql 2005 to Oracle 9. I have heard some of the 3rd part offerings are much faster than the MS or Oralce solutions

 

[onpnt]

I haven't heard of anything faster than a linked serve entry

although when I did my SQL Server to Oracle connection I didn't consider third party tools so that is not a testd statement.

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[ptheriault]

I just use a linked server. I have run into some problems with dara conversions, like Oracle numeric to SQL numeric, You have to convert everything to char then back to int. Kind of a pain.

- Paul
- If at first you don't succeed, find out if the loser gets anything.