CODEWITHSUNDEEP
c#sql-server-2008
Amin Jalali
Amin Jalali

Reputation: 321

What I have to have for running sqlserver?

I have a simple code that is using C# and Sqlserver 2008. For my C# code I get the .EXE file to customer and forced to install the .NET framework on her computer to run just the C# code.

But about the Sqlserver; I have installed the complete Sqlserver on my PC then attached my database on management part of that and am using the Sqlserver

now that I want to get my program to customer I install the .NET framework; but how can I run Sqlserver on her computer and attach the database each time?

Lets me to explain more:

The program will use on a local network and is multi_user.

I installed and am using the Sqlserver on my PC. I created my database and it's tables by help of sqlserver management tool.

for connecting to the datatbase I wrote a code that connect via the users IP address and I tested it on my PC with 2 Virtual machine. It is working truely.

My problem is here:

When I get the program to customer, what I have to do exactly?

What about the database I have to do? I have to install the whole Sqlserver on customer PC and set that PC as a server or I have a better way to do this?

Thanks.

Upvotes: 1

Views: 128

Answers (2)

Akrem
Akrem

Reputation: 4652

I have to install the whole Sqlserver on customer PC and set that PC as a server or I have a better way to do this?

yes you have todo all this work

1)install sql server and the management

2)install your database

3)remote your database to be used

Upvotes: 0

Gert Arnold
Gert Arnold

Reputation: 109292

If you want to use sql server as an embedded database for local storage, use sql server CE.

If you want your users to have access to a shared database you'll have to instal sql server (sql server express may do) on some machine in their network, configure the access rights, and adjust their connection strings accordingly. Or use SQL Azure.

Upvotes: 1

Related Questions