MS SQL Server 2005 Express Edition

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kress1963nov22@yahoo.com
    #1

    MS SQL Server 2005 Express Edition

    I recently purchased a good MS book ("Build a Web Site Now") by Jim
    Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on
    CD and also MS SQL Server 2005 Express Edition on the CD. A couple of
    questions for this newbie: Can MS SQL Server 2005 Express Edition be
    used in place of the older MSDE product for backend database work? I
    also have Visual Studio .NET (VB) 2003 (Standard Edition). How
    compatible are all these products and how should I approach using them?
    I do strickly database work (nothing fancy). Can I use MS SQL Server
    2005 Express Edition with Visual Studio .NET (VB) 2003? Can I start an
    ASP.net project in the Express Edition of MS-Visual Web Developer 2005
    and do any editing work on those pages later in my Visual Studio .NET
    (VB) 2003? Thanks! Dav

    Tags: None
    • Shane Story
      #2
      Re: MS SQL Server 2005 Express Edition

      SQL Express is great.

      Just read up on the limitations. MSDE had limitations. SQL Express has
      different ones. If they meet your needs, then go for it.

      SQL Express does have GUI tools for managing. This is a real plus.

      Neither is SQL Server, but they are free so what would you expect.

      HTH,

      Shane
      <kress1963nov22 @yahoo.comwrote in message
      news:1165886914 .809927.106030@ j72g2000cwa.goo glegroups.com.. .
      >I recently purchased a good MS book ("Build a Web Site Now") by Jim
      Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on
      CD and also MS SQL Server 2005 Express Edition on the CD. A couple of
      questions for this newbie: Can MS SQL Server 2005 Express Edition be
      used in place of the older MSDE product for backend database work? I
      also have Visual Studio .NET (VB) 2003 (Standard Edition). How
      compatible are all these products and how should I approach using them?
      I do strickly database work (nothing fancy). Can I use MS SQL Server
      2005 Express Edition with Visual Studio .NET (VB) 2003? Can I start an
      ASP.net project in the Express Edition of MS-Visual Web Developer 2005
      and do any editing work on those pages later in my Visual Studio .NET
      (VB) 2003? Thanks! Dav
      >

        Comment

        • aaron.kempf@gmail.com
          #3
          Re: MS SQL Server 2005 Express Edition

          I would expect offical SQL 2005 support in VS 2003 in the imminent
          service pack for VS 2003.

          this will add support for Vista; and I assume that SQL 2005 is a safe
          bet.. since MSDE won't ever run on Vista.

          You really might want to consider building things in SQL 2000 and then
          deploying them in Staging and Produciton in SQL 2005... It's really
          really not that hard; especially since SQL 2005 Express comes with the
          SSMS tools.. like you were talking about

          I mean; if the shoe fits-- wear it

          -Aaron

          PS - seriously the version of SQL Express you've got?? I would throw it
          away; but first wait a couple of days for the SQL 2005 SP2 Express.

          I like their new model.
          I just wish that they would build a reasonable frontend for data entry
          and reporting (like hmmm.. Access Data Projects maybe?)



          kress1963nov22@ yahoo.com wrote:
          I recently purchased a good MS book ("Build a Web Site Now") by Jim
          Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on
          CD and also MS SQL Server 2005 Express Edition on the CD. A couple of
          questions for this newbie: Can MS SQL Server 2005 Express Edition be
          used in place of the older MSDE product for backend database work? I
          also have Visual Studio .NET (VB) 2003 (Standard Edition). How
          compatible are all these products and how should I approach using them?
          I do strickly database work (nothing fancy). Can I use MS SQL Server
          2005 Express Edition with Visual Studio .NET (VB) 2003? Can I start an
          ASP.net project in the Express Edition of MS-Visual Web Developer 2005
          and do any editing work on those pages later in my Visual Studio .NET
          (VB) 2003? Thanks! Dav

            Comment

            Previous template Next
            Working...