what does 3rd party company do with database schema?

Hello,
my last question was what is a database schema? a third party company is coming in and my manager is asking me to provide them with schema's to my most used databases-
( which is going to be taking the work- but I thought on a positive note- I could at least learn something from this process)-
Like what in general will a 3rd party company do with my schemas?
rebuild the whole databases in different database languages? or is there software they might use to help convert the database say to sql server?
Just wondering in general what usually happens- so if have opportunity to meet any software people- I have some questions can ask ?
thank you
davetoughAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulfreelancerCommented:
All will depend on what they are engaged to do.
I've been given many schemas and then simply burned them - after I've delivered the requested review.

OR
However if engaged to implement a COTS system (commercial off the shelf) the schemas for Access databases might be used for a "data migration" - IF the data is considered important enough to cleanse and use.

OR
If engaged to implement a replacement system (maybe COTS, maybe not, maybe a mix) then the schema(s) of "as is" system may be v.important

so, to kick it off, the answer is "it depends"

What else do you know about the purpose of this 3rd party?
Perhaps research their website, it may give you a clue about them.
Look for "case studies"
Do they sell/support COTS systems, or are they a Gold partner of brandX?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I think the first comment made is a good one and covers the possible directions.

I'd only add that while the schema gives them an overview of what the database contains and how it is organizied, it doesn't tell them anything about how it works functionally.

If they indeed plan on replacing them, then the schema alone is not going to do it for them.

Jim.
0
Jeffrey CoachmanMIS LiasonCommented:
Like the previous experts have stated: "It Depends..."

More than likely, the thrid party will look to see if the design is properly normalized, has the appropriate keys and relationships, ..etc


...Note that the schema will not contain any "data"

I have seen databases with technically superior Schemas, but they were filled with invalid data.

So, like Jim, I can't see how an outside company can just look only at the Schema.

JeffCoachman
0
Luke ChungPresidentCommented:
I would concur with the others here that based on what you've given, it's not possible to determine what the people expect to do with the database schemas. However, in my experience, there's a tendency to want to get the schemas to then convince higher ups how easy it is to replace the Access applications. It may also be a way to show how poorly written the current Access databases are to justify the investment to migrate. The latter is a boogyman because anyone can review an existing database and offer suggestions -- it's not limited to Access or any particular database technology.

In dealing with outside reviewers, part of the review may be convincing them you have the proper processes in place to meet enterprise quality system administration. We've worked with many organizations to help them meet such reviews and created many products in our Total Access Ultimate Suite to help Access developers (and us) pass such scrutiny.

Getting the database schemas -- list of tables, fields, field definitions, relationships, etc. -- should not take long or be done manually. Our Total Access Analyzer program can generate that for you automatically for each of your databases.

If you deliver the reports from it, you can clearly show that you have the system administrative tools to professionally manage your Access databases. You can then bury them with the extensive cross-reference information that covers your forms, reports, and modules that is above and beyond the database schema, but necessary for anyone seeking to modify the application.

Good luck!
0
davetoughAuthor Commented:
thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.