[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1088) Importing from SQL Server, when multiple schemas exist for a login, will not show the tables in the schema
[
https://issues.jboss.org/browse/TEIIDDES-1088?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-1088:
----------------------------------------
Connected to same server as BOOKS in this example, but connected to NORTHWIND schema. Same
problem. SQL Server version: 8.0.760
Connected to "slntdb07.mw.lab.eng.bos.redhat.com" and connected to NORTHWIND
schem there and multiple schema were displayed. SQL Server version: 9.0.1399
Both of my connection profiles use the same driver, "sqljdbc4.jar"
Wondering if the DB's are set up differently???
Importing from SQL Server, when multiple schemas exist for a login,
will not show the tables in the schema
----------------------------------------------------------------------------------------------------------
Key: TEIIDDES-1088
URL: https://issues.jboss.org/browse/TEIIDDES-1088
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.4.2
Reporter: Van Halbert
Assignee: Barry LaFond
Priority: Blocker
When using Designer to import metadata from SQL Server database:
jdbc:sqlserver://slntdb02.mw.lab.eng.bos.redhat.com:1433;databaseName=books (user/pw =
books/mm)
the issue is the tables are not shown in order to import. This was confirmed by several
people. If Squirrel is used, then the underlying tables can be seen under
"dbo".
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira