It was recommended to me that I use SSMA to migrate data over to SQL. I was going to write a .Net script to move the data and also have tried using SSIS. I am connecting successfully to our DB2 instance through those means. So now I have downloaded and installed SSMA on our SQL Server and trying to connect to the DB2 instance and it has been running for a few hours now.
Because I have never used SSMA, is this normal behavior or it is downloading all of the AS400 metadata and schema when connecting? I actually was having errors when I first tried to connect with it actively refusing the connection, but I think I found the right port to get to it and the green bar has been working for a while.
Thanks for the info.