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

only showing one table

forums › forums › SQLyog › Using SQLyog › only showing one table

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • May 12, 2003 at 5:08 pm #7919
      sgtpepper
      Member

      I have recently downloaded SQLyog and it looks like what I need. I am trying to import data from a mssql 7 database using ODBC to a mysql database running on my linux box.

      When I do a ODBC import….it only shows 1 table…..it should be listing more than one table on the mssql database. Any ideas on what could be causing this?

    • May 12, 2003 at 5:15 pm #14256
      Ritesh
      Member

      Hmmmmmmmmmmmmm…..interesting

      Check out that the DSN is pointing to the correct database 😮 There should not be any problem with importing data from MS SQL

      HTH

    • May 12, 2003 at 5:34 pm #14257
      sgtpepper
      Member

      Yes, I have double checked it…and I accessed the mssql database with MS Access using the same DSN and see all the tables.

      Interestingly, the table that SQLyog is showing is the very first table in the list

      It is called….

      dbo.features_sum

      It is the only table with an _ I dont imagine this would cause the problem…..

    • May 12, 2003 at 6:09 pm #14258
      Ritesh
      Member

      Nope…that should not be a problem?

      Which version of MS SQL Server are you using and is the ODBC driver ODBC 3.0 compliant?

    • May 12, 2003 at 6:18 pm #14259
      sgtpepper
      Member

      I am not sure. Does it make a difference?

    • May 12, 2003 at 6:42 pm #14260
      Ritesh
      Member

      Normally it should not cause a problem.

      How big is the database? If its not very big then you can send me a backup of the DB so that I can give it to my development team to correct the error ( if there are any )

    • May 12, 2003 at 6:48 pm #14261
      sgtpepper
      Member

      Its well over 10,000 records in one table. The DB in total is very large. This is one of the reasons why I wanted to try SQLyog. Using access caused 'crashing' when trying to export a table as a CSV.

      What about this….can I somehow tell SQLyog which table to go to? Maybe I can force it into the table I want. It seems very bizarre that it shows the first table…but no more.

    • May 13, 2003 at 2:52 am #14262
      Ritesh
      Member

      Try this –

      After you give the DSN information, SQLyog will ask you whether you want to import data from the datasource or through a query.

      Select Use a query to specify the data, then in the next wizard write a query something like select * from tablename . SQLyog will list you the result with all the columns. Select them and import it. Please post the result out here for our information.

      HTH

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