I will definitely check the link you provided. In our case the external table is used only by this process. Can I migrate all those tables in one batch to SQL? if not, what's the best practice? One of my DB2 library contains 300 tables. My question is how do I migrate a library with all tables in that library and migrate them all in one batch to SQL. I followed the steps and was able to migrate one table from DB2 to SQL. This was a life saver for me since I am not a DBA and was looking for solutions/tools to migrate our DB2 data to SQL and decommission OBM AS400 sooner than later. Thank you for great article and very precise instructions. I haven't tried this with DB2, but SQL Server to SQL Server works fine. It allows you to select multiple tables, so you can select all of the tables in the library. I am not sure what would be the best practice for migrating entire library, but if I would have this task I would probably use SSIS Export Wizard. My quesiton is do I need to create all corresponding Tables and columns in SQL before going thru the Wizard? However, when tried to export to SQL, I receive the following message taht "The data type couldn't be assigned to the column "X" in "Micrsoft OLE DB Provider for SQL Server".
The SSIS Export Wizard seems to be working in selecting multiple tables from DB2 librray. I have just had a chance to go to this project. Thank you for the tip and sorry for late response. Hi is this still a live topic? I am in the process of doing the same AS400 to SQL Server and have never done this before. But you copy data from any data source that can be connected through an ODBC connection with SSIS. I am not sure what is the best way of doing this as I am not AS400 expert.
0 kommentar(er)
