Click here to Skip to main content
15,896,727 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi am new software student... i am doing project for our collae.. in .Net c#.. my project almost complate .. but i dont know how upload my sql database to my client computer when i tried to install whole sql server 2003 in retrain memory ... can use sql express only and can i upload database using sql express i will save my client's memory so can i do this.

What I have tried:

Hi am new software student... i am doing project for our collae.. in .Net c#.. my project almost complate .. but i dont know how upload my sql database to my client computer when i tried to install whole sql server 2003 in retrain memory ... can use sql express only and can i upload database using sql express i will save my client's memory so can i do this.
Posted
Updated 2-Sep-19 5:13am

1 solution

Quote:
how upload my sql database to my client computer
You do not do that. Databases are meant to be protected on the servers, behind secure firewalls and authenticated systems. Your SQL Server, MySQL and other databases are the meat of your business. You are a student, thus I am trying to explain to you how important it is to never share the database with the client, especially on their machines. You should consider using databases that are compact, and contain data that is of the user only, and not of any one else (other customers).

Instead of using SQL Server, why don't you consider using something like SQLite. SQLite is compact and light-weight, and only requires a single DLL to be available.

The databases can easily be moved from one machine to another, and clients don't require any installation. However, there are some limitations in the data types and SQL commands that are available.

If you can work without a few data types (use string data) and those commands (use alternative JOIN clauses), then I would surely recommend using SQLite. SQLite is what powers the databases in Android, iOS, and now Microsoft Windows also supports SQLite out of box; so you know you are not betting on a poor performance.

Read this article for more on that, Using SQLite in your C# Application[^]
 
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