June 10, 2008 at 5:28 pm
Please point me towards some good trusted (possibly economical) Data Migration and Conversion tools for converting legacy system SQL 2000 (XML, Image all data type) db data to SQL 2005 database (and possibly to Oracle too) in a totally different db schema/structure.
Thanks
June 10, 2008 at 6:56 pm
SSIS should definitely be able to move you from SQL 2000 to 2005, in fact you should be able to do a backup of the SQL 2000 database and restore it on 2005, that's if you are using the same structure.
SSIS should also be able to move you from SQL Server to ORACLE as well since ORACLE supports ODBC/OLEDB. There is certainly some effort involved especially in migrating to a new schema.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 11, 2008 at 6:16 am
I agree with Jack. It's like you wrote a product description for SSIS.
For going to Oracle, I'd suggest getting this third party destination device. Otherwise, moving the data to oracle is a HUGE pain.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply