Import Data From Ms Sql Views

[Ritesh]

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.

[peterlaursen]

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' …

[Robert Shera]

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

[Ritesh]

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.

[Robert Shera]

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