While using batch import/export tool I found to have two main issues. 1. Java.lang.OutOfMemoryError: Java heap space 2. Duplicate column issue while migrating table metadata using Import tool. Solution for Java out of memory error: 1. Go to SASHOME/SASPlatformObjectFramework/9.4 2. Modify the value of JavaArgs_1 with higher value in ExportPackage.ini and ImportPackage.ini. Default is 512M, change it to higher value say 2048M. Solution for duplicate column issue while importing. For this modification needs to be done only on ImportPackage.ini. Add following line: -Dsas.promotion.columns.deletetargetcolumns=true
Blog about SAS® platform administration and working with SAS metadata.