Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. Creating Database during Installation

Creating Database during Installation

Scheduled Pinned Locked Moved C#
databasesql-serversysadmintutorialquestion
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Offline
    T Offline
    Taurian110
    wrote on last edited by
    #1

    I am working on a windows app. I need to create a database during installation but more importantly, I need to know how my application would work on a computer that does not have SQL Server installed:wtf:. Since it is a stand alone app I am assuming that 99% end-users will not have SQL Server on their computers. Can I create a database if just the SQL Driver is available on client PC? or any other better suggestions? A code example will really be helpful. Thanks.:)

    S 1 Reply Last reply
    0
    • T Taurian110

      I am working on a windows app. I need to create a database during installation but more importantly, I need to know how my application would work on a computer that does not have SQL Server installed:wtf:. Since it is a stand alone app I am assuming that 99% end-users will not have SQL Server on their computers. Can I create a database if just the SQL Driver is available on client PC? or any other better suggestions? A code example will really be helpful. Thanks.:)

      S Offline
      S Offline
      Steve Maier
      wrote on last edited by
      #2

      I have worked at places that do this in a couple different ways. You could copy the database files over to the machine and then attach a new database in SQL Server using a sql command. Or you could just generate the sql for the entire database and have that run on installation. In either case you will have to make sure that SQL Server is installed on the target machine. You can put the MSDE installer inside your installer and even SP3 for it too. SQL Srver is not like Access, you need to have the server running on the machine to get at it. For one product of mine, I switched to SQLite because that is accessed just as a file. I get most of the same features that I need and not much overhead. Steve Maier, MCSD MCAD

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups