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
plut0564 0 Newbie Poster
Ramy Mahrous 401 Postaholic Featured Poster
what about SSIS? I didn't use SSMA.
You can use SSIS to move\copy data in fast and smooth way.
plut0564 0 Newbie Poster
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
Ramy Mahrous 401 Postaholic Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.