Re: Development Cycle

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: TC (no_at_email.here)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 12:46:54 +1030

"Terry" <Tezza.TLL@btinternet.com> wrote in message
news:eomhlH8#DHA.2800@tk2msftngp13.phx.gbl...

(snip)

> i guess what i really want to know is this: Is SQLServer as user-friendly
as
> Access and, given that i have a good understanding of SQL and MS products,
> will I be able to find my way around the application intuitively? If
that's
> still unclear, then perhaps I should just assume I can :)

I've not used SQL Server myself. However, it is basically just another
enterprise-level DBMS (database management system) - and I have used other
such products, eg. Oracle.

In most such products, you have an underlying database management product
(the DBMS), and a set of associated development tools for writing programs,
forms & reports etc. for use with that product.

                      DBMS Development tools

Access MS Jet MS Access

SQL Server SQL Server ?

I don't know what the development tools are called in SQL server. Your
question really is, are those tools as eay to use as MS Access. I don't know
the answer to that, so someone else might jump in here (or you could post
that as a new question).

However, be aware that the complexity of the DBMS part, will definitely be
greater than the complexity of MS Jet. For example, all enterprise-level
DBMS's have special features for taking live backups, or restoring the data
after file corruption. MS Jet has no such features. Enterprise-level DBMS's
have so-called "ACID transactions". MS Jet has no such feature, & so on.

So there is a learning curve for the DBMS part of SQL Server, over & above
the learning curve its development tools (whatever those are). A "database
administrator" would be expert in the DBMS part, and hopefully have a
reasonable understanding of the development tools. Conversely, a "database
programmer" or developer, would be competent in the development tools, but
would not necessarily know much about the underlying DBMS.

Hope this helps. Good luck with the job!

TC

Relevant Pages

  • Re: ConnectionString using DSN not working
    ... applications that can work regardless of which backend database engine is ... This assumes that each DBMS is the same--supports the same SQL ... take advantage of the specific features you pay for when you buy SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Performance / Profiling tools for ASP.NET applications
    ... We are currently looking into extending our development tools with good ... We know of the new Visual Studio 2005 Team editions as well as DevPartner ... Microsoft Stress Test application doesn't feel like the complete deal). ... We are using Windows 2003 Servers, SQL Server ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Performance / Profiling tools for ASP.NET applications
    ... We are currently looking into extending our development tools with good ... We know of the new Visual Studio 2005 Team editions as well as DevPartner ... Microsoft Stress Test application doesn't feel like the complete deal). ... We are using Windows 2003 Servers, SQL Server ...
    (microsoft.public.dotnet.framework.performance)
  • Re: Protecting database from administrators
    ... You're not the first looking for better security features, ... But, in their defence, MS want SQL Server as a mass-market ... dbms, so they put their resources into features that will earn them the most ...
    (microsoft.public.sqlserver.security)
  • Re: Selective views
    ... MS Access is an interactive, client interface for the MS Jet, ... semi-relational DBMS. ... If you create a MS Access database with links to SQL Server or pass-through ...
    (microsoft.public.sqlserver.server)