3

I have developed a c# application connected to a SQL Server 2008 database, and I want to make a project install. How can I include my database in the application without having to have SQL Server 2008 installed?

Collin
  • 11,977
  • 2
  • 46
  • 60
Abdelilah Aassou
  • 148
  • 3
  • 15
  • Are you discussing the embedded version of SQL server? – code4life Mar 07 '13 at 15:10
  • If you are speaking about the SQL 2008 Std. Edition, you can't do that. What you might want is to use Compact Edition. – YvesR Mar 07 '13 at 15:10
  • Sorry, that's what I meant. SQL CE 3.5 ships with SQL 2008. Here's the link: http://www.microsoft.com/en-us/download/details.aspx?id=5821 – code4life Mar 07 '13 at 15:14
  • Just one question. Do you want to know, how you can 'install', I would prefere 'create' the DB on the clients DBMS, because the DBMS is a prerequisite? Or do you really want to install the DBMS and then create the DB? – DHN Mar 07 '13 at 15:16
  • i want install my application that will be include my db – Abdelilah Aassou Mar 07 '13 at 17:11

1 Answers1

1

It is not possible. you better use SQL SERVER COMPACT EDITION, if you don't want to install sql server in client's system. Sql Server Compact edition enables you to create a local database that can be accessed without sql server. But using it you will not be able to use your application on networking.

kashif
  • 3,713
  • 8
  • 32
  • 47
  • ok i understand that using sql server compact edition we can't use a network application. It's possible with sql server express edition ? – Abdelilah Aassou Mar 07 '13 at 15:55
  • yes it is. Read this article http://msdn.microsoft.com/en-us/library/ms165647(v=sql.90).aspx – kashif Mar 07 '13 at 18:18