Our data warehouse data Models are not in sync with our Database. We are trying to reverse engineer from database. Then compare and merge.
while doing one schema which has about 259 tables, I am getting the error as below It is working worked for small schema.
Any advise or help will be appreciated..
Are you using ODBC to reverse engineer or the native client connection? I believe that in the other thread you mentioned that your database is Oracle. If that's the case then I would suggest using the native client and the Oracle alias to connect to the database. I've only seen this error with ODBC connections.
Thank you. Choosing Native/Direct Connection: what would be the Data Source? Do i need to create one? and how?
i used at jdbc:oracle:thin:@hostanme/servicename
did not work
Using the Native/Direct connection requires the full Oracle client to be installed. It then uses the Oracle tnsnames.ora alias as the datasource to connect to the database. Here are links to some of our docs:
i wonder how ODBC works for smaller number of tables at once
Worked like a magic! I did not realize it was looking the entry from TNS file