Has anybody used this microsoft tool SSMA?
I can connect the two databases OK, and can convert tables from ORACLE to SQLSERVER 2005, but the data refuses to go across.

Any info will be helpful.

Thanks,
Jim

what about SSIS? I didn't use SSMA.
You can use SSIS to move\copy data in fast and smooth way.

Ramy,

Unfortunately, I'm more Oracle than sqlserver is the SSIS method simple. I will need to be if I'm going to use it !!!

Cheers,

Jim

It's independent ETL solution by Microsoft but from any source to any destination and you don't need to have SQL Server as software or staging to move data, I highly recommend you to use it, any help regarding this I'm here.