We have an ERP system on IBM AS400. To migrate to to new ERP system, the first requirement is to take the whole 5000 tables from AS400 TO SQL serevr 2012 and then massage and filter the data from SQL serevr.
What is the best way to do this quickly. The field names can be same on the tables.
We have SQL 2012 standard edition.