I am writing a java app on my machine and it works perfectly with the establishment of DB, but when I establish that this site is running because DB is slightly different.
So I am in the process of writing some code to verify:
-
A: I have found the DB details correct
-
B: There are all the tables in the database that I expect and they have the correct columns.
I got it under A but I do not know how to start with B, any suggestions?
The target DB is Oracle for the existing client, but the app can be configured to run on SQL Server so a generic solution will be appreciated, but I am not sure because of this I am convinced How can i make one another
You want to ask the database's information_schema, here are some examples of Oracle, I know That's something similar in every platform.
Comments
Post a Comment