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

Import Data From Ms Sql Views

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Import Data From Ms Sql Views

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • May 22, 2006 at 10:29 am #9698
      Robert Shera
      Participant

      Are there any plans to allow importing of data from MS SQL views in an ODBC import? I am looking for a solution for synchronising data from a SQL Server database that exposes the data I need via views, and because it is part of a third-party app there is considerable difficulty in exposing the data directly from the tables.

      I don't need to create the views in MySQL, just get the data from them.

      I guess I could use the SQL DTS to export the data to an access database and then get it from there, but one step is better than two, and I might also have problems with accessing the Windows 2000 server from my network, as it isn't really “part” of my network.

      Thanks in advance

      Rob

    • May 22, 2006 at 10:40 am #21689
      Ritesh
      Member

      Let me check the ODBC documentation and figure out how to get VIEWS in addition to TABLES in SQL Server.

      I will let you know about the feasibility.

    • May 22, 2006 at 10:48 am #21690
      peterlaursen
      Participant

      This is not supposed to be an answer, but some additional questions and considerations …

      1) Does the ODBC-driver expose the views? Try connecting to the 'external datasource' from Access or OpenOffice Base using ODBC. If not a Migration tool using ODBC of course cannot.

      2) If possible at all, I think it will only be possible to import to a table, as the view only makes sense as a VIEW when the table(s) used for its construction is available.

      .. and looks like Ritesh is 'on track' …

    • May 22, 2006 at 9:19 pm #21691
      Robert Shera
      Participant

      Thanks for the prompt responses! 🙂

      peterlaursen wrote on May 22 2006, 08:48 PM:
      1) Does the ODBC-driver expose the views? Try connecting to the 'external datasource' from Access or OpenOffice Base using ODBC. If not a Migration tool using ODBC of course cannot.

      Yes, the ODBC driver does. I can see (and import data from) the views using the ODBC connector from MS Access.

      Rob

    • May 23, 2006 at 1:30 pm #21692
      Ritesh
      Member

      Thanks for pointing that out. If Access can, SQLyog should also be able to do.

      I have added this in the TO-DO list of SQLyog.

    • May 23, 2006 at 9:27 pm #21693
      Robert Shera
      Participant

      Thanks Ritesh – much appreciated.

      Rob

      Ritesh wrote on May 23 2006, 11:30 PM:
      Thanks for pointing that out. If Access can, SQLyog should also be able to do.

      I have added this in the TO-DO list of SQLyog.

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