Re: Moving data from SQL-Server
- From: Grant Allen <gxallen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 May 2006 08:51:18 +1000
Nirmalya Das wrote:
Does anyone have experience in moving SQL-Server data to Oracle 10g?
If so, it willl be greatly appreciated if you could post your experience.
Plenty of tools out there to help. Depending on your background,
Migration Workbench is good, as is DTS/SSIS - especially if this will be
a regular event. If you're talking stupendously large amounts of data,
OWB gets the job done (though it's not "friendly" IMNSHO).
And then test, test, test. Watch for things like datatype conversion,
very long varchar data, decide what you'll do with image datatypes if
you have them, etc.
Ciao
Fuzzy
:-)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
