Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Filter For Tables In Import Wizard

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Filter For Tables In Import Wizard

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • March 22, 2013 at 5:55 pm #12955
      br8kwall
      Member

      I'm setting up a few connections to import data from Oracle to MySQL via ODBC through SJA. But I have hundreds of tables that I need to scroll through each time in the dialog. Can you please add some kind of filter to limit the tables that are returned/shown to the user?

    • March 25, 2013 at 4:40 am #34257
      sathish
      Member

      Hello,

      We have added this request in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=1924 We will schedule this according to priority.

      Regards,

      Sathish

    • March 25, 2013 at 4:06 pm #34258
      br8kwall
      Member

      Thank you. PS. other programs I use are able to also show me additional information about the table through the ODBC connection. For example, just seeing the Oracle schema name as a prefix on the table names would be a minor help here if the filter isn't possible.

    • March 25, 2013 at 6:30 pm #34259
      br8kwall
      Member

      I didn't realize the root problem until just now – but this issue just cost me a half-a-day. In our Oracle we have several versions of the same database – so several tables of the same names across several named tablespaces.

      When importing from the same ODBC connection as SQLyog MS Access and other ODBC tools limit the tables to one table space. But (feature or bug) SQLyog shows them all to me in one long list. I spent the morning repeatedly selecting and importing the wrong PERMIT_INFO table and banging my head. Many were available in the import list (which I didn't realize) without me able to tell which table space they were in, or limiting the table space to just one. Let me know if you need more information.

    • March 26, 2013 at 6:07 am #34260
      sathish
      Member

      Thank you for the information. Currently we are busy with V11.1 release. We will look into it after GA release probably after 2 weeks.

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.