C# SQL Server: Application works with database from another pc

Question

I have my application written in C#, it uses a SQL Server database. I have a connection to a database in my C# code, some queries to write/read from database.

Now consider following: if I want to run this app from another PC, this PC has no SQL Server, will this app work? (I assume not) If not then how can this another PC still work with database? Is there a way to programmatically create database on another PC using C# so it has a name I need, columns I need. I created my database using SQL Server Management Studio.

You can either back-up and then restore the database, or 'script the database out' (using the tools in SSMS) to avoid re-creating it from scratch if you didn't save the scripts... — Milney
– Milney, Commented Mar 31, 2017 at 7:39

Community · Accepted Answer · 2017-05-23 12:32:19Z

0

I guess your application works with a local server. First of all you should check in your application at startup if there is any local mssql server running. If not, you should handle it by installing one programmatically.

Read this answer how to do this if you don't know it.

After that you have to create the database, it's tables, maybe adding user priviliges. Write a SQL script that gets started by a class that starts it.

Read this to see how to start a SQL script in C#

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Mar 31, 2017 at 3:24

Archimedes

2311 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frankenstine Joe · Accepted Answer · 2017-03-31 06:07:08Z

0

You can do this by setting up SQL server on another machine (server).

Set that servers authentication to SQL Server authentication (requires username and password for that SQL server Management Studio)

Change the connection string in web/App.config from your C# app to use that servers Ip address and Credentails for SQL server

answered Mar 31, 2017 at 6:07

Frankenstine Joe

3236 silver badges16 bronze badges

Collectives™ on Stack Overflow

C# SQL Server: Application works with database from another pc

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related