October 11, 2017 at 7:37 am
It's probably a VIEW. You might well find other views that are dependent on the tables they select data from, but the existence of a view doesn't necessarily define any relationships between tables. You're going to need to have someone TELL you what's what, because there is not likely to be ANY one query that will give you that information. It can take a VERY LONG TIME to figure this stuff out from application code. Talk to a human being and start asking questions.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 11, 2017 at 4:06 pm
sgmunson - Wednesday, October 11, 2017 7:37 AMIt's probably a VIEW. You might well find other views that are dependent on the tables they select data from, but the existence of a view doesn't necessarily define any relationships between tables. You're going to need to have someone TELL you what's what, because there is not likely to be ANY one query that will give you that information. It can take a VERY LONG TIME to figure this stuff out from application code. Talk to a human being and start asking questions.
Our last DBA didnt left any documents relating to the database and now we have a task of setting up a training enviornement where i need to extract some data from the database and put it there ... sadly, I am the only sql dba out there ; )
October 11, 2017 at 4:46 pm
aloshya - Wednesday, October 11, 2017 4:06 PMOur last DBA didnt left any documents relating to the database and now we have a task of setting up a training enviornement where i need to extract some data from the database and put it there ... sadly, I am the only sql dba out there ; )
It may not have much to do with the former DBA. Check with the developers or whoever wrote the application as the relationships are apparently done through application logic rather than database constraints. Maybe there is some application documentation somewhere. Talk to those who were involved in the application project in anyway - developer, an analyst, a project manager or manager, really depends on the company.
I'd double check whatever data you extract. Typically when it all depends on application logic, bad data will get in there. There is nothing to stop that from happening when there are no constraints in the database. Application bugs, direct table access and things like that will allow bad data to get in the tables.
Sue
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply