[junaidjee]

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.

[negligible]

Is it MySql you are thinking of?

[junaidjee]

No it is Ms server..

[Curtis Rutland]

Sql Server Compact

[Sergio Tapia]

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.

[junaidjee]

ok and what for oracle alternative. Thanks.

[AdamSpeight2008]

Sql Server Compact also doesn't require full administrator rights.

[Curtis Rutland]

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.

[junaidjee]

Thanks for the replies you give me guys... thanks alot... it really increase my information....