Hi, I'm looking to reverse engineer a Physial Data Model from an Azure SQL Database via ODBC. I'm using odbc 17 for SQL Server. Tables get regenerated but no objects are present in terms of columns / indexes etc...
When trying to connect, I get an error message saying -
Unable to list the triggers.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Catalog view
'trigger_events' is not supported in this version
SQLSTATE=37000
Now, after clicking okay, I can see the tables and when I choose them for reverse engineering - got the following:
Reverse Engineering Reverse engineers the database ... Unable to list the rules. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'syscomments' is not supported in this version. SQLSTATE = 37000 Reverse engineering tables...
Table DAY_MTD Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000
Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000
Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000
Table DAY_OF_WEEK Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version.
SQLSTATE = 37000 Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000
Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000
Table DAY_YTD Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000
Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000
Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000
Table GEO_SOURCE Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000
Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000
Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000
4 object(s) have been reverse engineered. Reverse engineering references... 0 object(s) have been reverse engineered.
Request clarification before answering.
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.