creation of data base using sql server

Question

0.00/5 (No votes)

See more:

Hi,
I am trying to implement a software for a friend, and this software will be used for manipulation of a gym(bodybuilding gym), but I have the problem of how to create a data base for the software since the user will only use his computer(no server). So, how can I create a database (connected to the software), that is accessed but more secured,and what I mean by that is that if the user decided to fomatte his comuter, the database should be moved and it should work again with the same software.
if you need more explanation please let me knwo.
Thank you

Posted 17-May-11 2:15am

anyavacy

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

fjdiewornncalwe · Answer 1 · 2011-05-17T02:18:00

Solution 1

Without a separate server he will lose everything if he "formatte his computer". The purpose of formatting is to wipe out all data. For this reason, there is NO WAY to get the database to magically back itself up somewhere else. If you want to secure the data, have him invest in a small server and put the database there. Ideally that server will have a backup system of some kind to back up the data.

Posted 17-May-11 2:18am

fjdiewornncalwe

Comments

anyavacy 17-May-11 9:38am

so if the user does not have the intention to invest on a server, this software will be useless if a his computer becomes infected?

fjdiewornncalwe 17-May-11 10:45am

Short answer: Yes.
Long answer: I never like maintaining data and user applications on the same machine, but if it is required, another economical option is to have a large, external usb hard drive that can be attached once every couple of days to backup the critical data. At least then the data would at worst be only as out of date as the latest backup.

anyavacy 17-May-11 10:46am

thank you very much for your help

Albert Holguin · Answer 2 · 2011-05-17T04:46:00

Solution 2

You can always set up some sort of automatic backup system to backup the database to either a server somewhere else or some sort of cloud based storage solution.

Posted 17-May-11 4:46am

Albert Holguin