Hello Everyone,
I am working on an application which has a part of its data on Sybase.
We are required to migrate all the data (with Tables/ SPs and of course the data) on to DB2 on AS400 as that is the main database.
We have downloaded MTK migration tool kit to do this job. But we are facing lot of issues wiht this.
It converts only 70% of the data and leaves the code whihc has Outer Joins and other sybase keywords/functions...
Here are the problems - summarized -
*) We are not able to find the coressponding fucntions/key words in DB2 for keywords like - @@SPID, ProcID, USerid or USerName etc
*) As we need to finalize the data porting strategy, we tried BCPing files from Sybase to our pc and then FTPing to AS400 server, whihc is taking around 3-4 days . we have tried other options like CPY command on AS400 but that is also taking hell lot of time.
COuld you please suggest and guide me in this direction.
Many Thanks in advance!! and hoping to get a helping hand!!
Regards,
Shuchi
I am working on an application which has a part of its data on Sybase.
We are required to migrate all the data (with Tables/ SPs and of course the data) on to DB2 on AS400 as that is the main database.
We have downloaded MTK migration tool kit to do this job. But we are facing lot of issues wiht this.
It converts only 70% of the data and leaves the code whihc has Outer Joins and other sybase keywords/functions...
Here are the problems - summarized -
*) We are not able to find the coressponding fucntions/key words in DB2 for keywords like - @@SPID, ProcID, USerid or USerName etc
*) As we need to finalize the data porting strategy, we tried BCPing files from Sybase to our pc and then FTPing to AS400 server, whihc is taking around 3-4 days . we have tried other options like CPY command on AS400 but that is also taking hell lot of time.
COuld you please suggest and guide me in this direction.
Many Thanks in advance!! and hoping to get a helping hand!!
Regards,
Shuchi