Click here to Skip to main content
15,884,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,guys i publish my program in c# VS,i have a database(sql server) that connected to my program,when i publish my program and use that in another pc i must install sql server in another pc and create a data base for running my program,how can i make a internal data base and install my program and use that with out install sql server in another pc
sry my english is bad :(

What I have tried:

sql server managemment system .......
Posted
Updated 21-Mar-23 0:55am
Comments
PIEBALDconsult 21-Mar-23 9:02am    
Not with the full SQL Server, but maybe with SQL Server Compact.

1 solution

If you're not particularly interested in having multiple applications connect to your database server at once, and this is just for a standalone application, you might want to consider using a different database such as SQLite[^].

This simply relies on created a file somewhere on the file system, eliminating the need for a fully-fledged server installation. You may need to adjust your application though to behave differently, however if you're using EntityFramework I'm sure the transition would be fairly easy.

If you are interested in multiple applications access the database, you'd probably want them to install the database on a server somewhere in the network (once) and have all applications connect to it. Though, that's not very secure so I'd instead recommend building a REST API[^] instead.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900