|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 29, 2009 3:25 AM
Points: 3,
Visits: 74
|
|
Hi
I have to migrate data from Oracle db. I have a similar fresh database in sql server 2005 with the schema corresponding to the Oracle. For Data Migration, which will be the better option SSIS or SSMA. Please advice.
Thanks in Advance,
Palani
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, June 29, 2009 6:21 AM
Points: 207,
Visits: 387
|
|
| If this is a onetime (or two time, test and then production) data transfer, you could probably get a way with the Import Data wizard in SSMS. If you will need to schedule and possibly fine tune your migration (as is in my mind likely) you should use SSIS. There are migration wizards within that can automate the creation of the initial package(s), but you will most likely need to modify them afterwards.
|
|
|
|
