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
Recommended Answers
Jump to Postwhat about SSIS? I didn't use SSMA.
You can use SSIS to move\copy data in fast and smooth way.
All 3 Replies
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.