Can someone who is considered an expert with Access Databases easily begin developing in SQL Server? How about Oracle?
The answer is the ever popular "it depends".
The database engine doesn't really have a huge impact on the developer's skill set. Some engines do a bit more or less than others, but the real issue is the ability of the developer to write code that will do what is needed.
A person who is considered an expert at using Access is usually very good at developing single user databases. While the Jet database engine that Access uses can develop multi-user applications, the features in Access naturally lend themselves to single user applications. These database designs are great for jobs that can be solved by one person.
Client/Server databases require a different skill set than single user databases. In these databases, dozens or hundreds of users are trying to access the database at the same time instead of a single user. Issues of concurrency (locking/blocking/etc) become significant, indexing moves from interesting to crucial, and the design considerations change radically from single user databases. The simple solutions that Access encourages become a liability at this point.
Internet (Web) service databases are still different. These databases can have quite literally thousands of simultaneous users. The ability to design databases that will scale successfully becomes crucial. Performance becomes a significant factor, overriding almost everything except getting a "correct" answer.
The short answer is that yes, an Access developer can easily switch their data engine from Jet to MS-SQL or Oracle, but that doesn't mean that that developer will automatically have the skill set needed to develop these new types of applications.
For More Information
- Dozens more answers to tough database design questions from Pat Phelan
- The Best Database Design Web Links: tips, tutorials, scripts, and more
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your database design questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Related Q&A from Pat Phelan
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.