I have been able to use ms access driver and some of the oracle tables do come over one of the common errors I receive is duplicate column information in the auto generated SQL. It is kinda of bizarre. When I look at the table there are no duplicate column names. It appears to have problems with the Oracle driver.
I believe I figured out what is specifically going on. When oracle tables have indexes set the auto import feature works no problem. When Oracle has no index set it ask which field do you want to use as the index.
A feature that is not reflected when using the auto import in sqlyog.
Hence I believe this is the reason why the autogenerate SQL duplicates itself and thus errors generated importing the data. If you try an import into access you will see it first pulls the data and the second a prompt says which field is to be used as an index.
This is where I believe the import feature in SQLyog is getting hung up.
