the wizard asks you for the name of your migration project and a directory into which it places files. Have a look at that directory. It should contain a file with extension .sql and a file with the extension .out. The .sql file is the script that is applied to create the metadata in the target database, and the .out file is the log of applying the .sql file. So have a look at the .out file, it might contain the errors that are returned if a table creation has failed.
And yes, manually copying does not migrate constraints, indexes, etc. That is working as designed and it is described in the documentation.