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?