Packaging a SQL2005 application

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Ryan Langton

    #1

    Packaging a SQL2005 application

    I've created quite a few .Net apps we use locally and I generally just
    publish them as ClickOnce applications to a network drive. Now I'm being
    asked to make my app portable to other networks/companies. So I want to
    create a setup program on CD/DVD. The hurdle here is that my apps are often
    database driven and use SQL2005 as the backend. I'm not sure how to go
    about doing this and just looking for a point in the right direction. I'm
    currently using Visual Studio 2008 (Visual Basic), SQL 2005, and most of the
    apps were created with .Net2.0.

    Thanks,
    Ryan


  • RobinS

    #2
    Re: Packaging a SQL2005 application

    SQL2005, not SQLServer Express or SQLServerCE? (Just checking).

    RobinS.
    GoldMail.com

    "Ryan Langton" <langton@ci.man hattan.ks.uswro te in message
    news:eE6VwsPiIH A.2416@TK2MSFTN GP04.phx.gbl...
    I've created quite a few .Net apps we use locally and I generally just
    publish them as ClickOnce applications to a network drive. Now I'm being
    asked to make my app portable to other networks/companies. So I want to
    create a setup program on CD/DVD. The hurdle here is that my apps are
    often database driven and use SQL2005 as the backend. I'm not sure how to
    go about doing this and just looking for a point in the right direction.
    I'm currently using Visual Studio 2008 (Visual Basic), SQL 2005, and most
    of the apps were created with .Net2.0.
    >
    Thanks,
    Ryan
    >

    Comment

    • Ryan Langton

      #3
      Re: Packaging a SQL2005 application

      We're using SQL 2005, not express. That could be one of the issues that
      other companies may not have SQL 2005 or a dedicated database server. Would
      SQL Express be a viable solution for networked applications with say 5-10 or
      possibly more users? I've created a SQL query to create the database and
      tables, is there any way to package this query in the Install setup?

      Thanks,
      Ryan

      "RobinS" <robins@imnotte lling.comwrote in message
      news:YaSdnb5gq6 _-HH3anZ2dnUVZ_qy gnZ2d@comcast.c om...
      SQL2005, not SQLServer Express or SQLServerCE? (Just checking).
      >
      RobinS.
      GoldMail.com
      >
      "Ryan Langton" <langton@ci.man hattan.ks.uswro te in message
      news:eE6VwsPiIH A.2416@TK2MSFTN GP04.phx.gbl...
      >I've created quite a few .Net apps we use locally and I generally just
      >publish them as ClickOnce applications to a network drive. Now I'm being
      >asked to make my app portable to other networks/companies. So I want to
      >create a setup program on CD/DVD. The hurdle here is that my apps are
      >often database driven and use SQL2005 as the backend. I'm not sure how
      >to go about doing this and just looking for a point in the right
      >direction. I'm currently using Visual Studio 2008 (Visual Basic), SQL
      >2005, and most of the apps were created with .Net2.0.
      >>
      >Thanks,
      >Ryan
      >>
      >

      Comment

      Working...