Data Migration Assistant

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
palmeal
Participant
Posts: 122
Joined: Thu Oct 14, 2004 7:56 am
Location: Edinburgh, Scotland

Data Migration Assistant

Post by palmeal »

I'm now looking at the data migration assistant and see that there is no option for Sybase or MSSQL Server. Is there plug-ins for these vendors or does one of the existing options work ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You're right, there's no SQL Server or Sybase provided.

Choose DB2 or Oracle from the drop-down list (step 2 or step 4 in the Wizard). DB2 asks for database name and server name, Oracle asks for user name only.

Create the job (you can load the table definitions from anywhere in the Repository, provided you've already imported/created them). Then change the stage types.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply