8 Replies - 3025 Views - Last Post: 12 December 2011 - 04:04 PM

#1 junaidjee  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 47
  • Joined: 06-September 07

Have i to tell software user to install full sql server

Posted 11 December 2011 - 04:48 PM

I am new to .net world. I want to ask that if i make a software in vb.net or c#.net and that software is using sql server or oracle as a database. Then suppose i make a setup file for my software and deliver to my client. So now the client will have to install full sql server software or full oracle software? Is there any small program that manages all the databases so that my client dont need to install full sql server software or full oracle software. My friend told me that there is some sql client db that you use but he dont remember its name. So please tell me how can i do it. Thanks in advance.

Is This A Good Question/Topic? 0
  • +

Replies To: Have i to tell software user to install full sql server

#2 negligible  Icon User is offline

  • D.I.C Regular

Reputation: 62
  • View blog
  • Posts: 302
  • Joined: 02-December 10

Re: Have i to tell software user to install full sql server

Posted 11 December 2011 - 05:14 PM

Is it MySql you are thinking of?
Was This Post Helpful? 0
  • +
  • -

#3 junaidjee  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 47
  • Joined: 06-September 07

Re: Have i to tell software user to install full sql server

Posted 11 December 2011 - 05:26 PM

No it is Ms server..
Was This Post Helpful? 0
  • +
  • -

#4 Curtis Rutland  Icon User is online

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 4531
  • View blog
  • Posts: 7,903
  • Joined: 08-June 10

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 08:53 AM

Sql Server Compact
Was This Post Helpful? 1
  • +
  • -

#5 Sergio Tapia  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 1253
  • View blog
  • Posts: 4,168
  • Joined: 27-January 10

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 09:37 AM

I've never heard of a software actually installing a full on SQL Server instance on a client machine.

Since this is a very heavy change to the client machine I don't recommend you do this.

Have you considered using something like Sql Server Compact Edition or SQLite? Both are databases yet they are contained in a single file. Perfect for deploying on a client machine without devastating his resources.

Both are supported by popular ORM's such as Entity Framework 4.
Was This Post Helpful? 1
  • +
  • -

#6 junaidjee  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 47
  • Joined: 06-September 07

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 02:27 PM

ok and what for oracle alternative. Thanks.
Was This Post Helpful? 0
  • +
  • -

#7 AdamSpeight2008  Icon User is offline

  • MrCupOfT
  • member icon


Reputation: 2268
  • View blog
  • Posts: 9,482
  • Joined: 29-May 08

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 02:32 PM

Sql Server Compact also doesn't require full administrator rights.
Was This Post Helpful? 0
  • +
  • -

#8 Curtis Rutland  Icon User is online

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 4531
  • View blog
  • Posts: 7,903
  • Joined: 08-June 10

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 03:21 PM

There is no "Oracle alternative", because Oracle has never released a compact version of their database. If you absolutely rely on Oracle, then you have to install an Oracle instance. Therefore, I suggest not relying on Oracle.
Was This Post Helpful? 0
  • +
  • -

#9 junaidjee  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 47
  • Joined: 06-September 07

Re: Have i to tell software user to install full sql server

Posted 12 December 2011 - 04:04 PM

Thanks for the replies you give me guys... thanks alot... it really increase my information....
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1