Data Management Advice

[dom24]

Can someone please advise me of the best method to use to manage the data in my SQL database?
I have tried to get information from the web but i'm not having much luck.
All I want to know is the most common method of allowing admin staff to update and edit the records stored in a database.
Thanks.

 

[Corran007]

define admin staff?
admin dbas? admin owners(users) of the programs that enter data?

if your talking dbas, most use em or qa to update and edit.
if your talking about the users, i would use something without direct access. if you do not have a program, i would suggest making one.

You need to define your question a bit futher.

 

[dom24]

Sorry, I mean admin staff as in owners of the programs that enter the data. They have no database experience at all therefore need the easiest most appropriate way of updating tables on a regular basis as possible.

Just out of curiosity, what do you mean by em and qa?
And how would I go about making a program? Do you mean buy in some software that has these features?

 

[Corran007]

em is enterprise manager, qa is query analyzer.

im guessing the programs provide no way to change the data? they should really. i would start by asking the makers of each program what they recomend for it. Perhpaps they have a tool you or your users are not aware of.

you could buy something i guess. i would write an application to allow them access, but thats me. Honestly ive yet to encounter an application that did not have a way to change the data from the progarm itself

 

[SQLSister]

SQL Server unlike Access does not have a user front end package that goes along with it. YOu must design and program one yourself for the users to access and manipulate data. People generally use, Access, >net, ASp, VB or someother program to create the user interface.

What is the best way to allow the users to actually enter and update data depends completely onthe circumstances. If you only have one or two poeple who will be entering and updating data from a local office, Access is probably the simplest and fastest interface to use. If the users need web access or need remote out of the office access, the a swebsite built from asp, or J@EE or .net is probably a better choice.

In any event you basically create a form that has the data entry fields and then allows th user to change delete or add data. Each of these actions runs a SQL Stament or stored procedure to perform the action. You will also need to create programs to validate the data based on business rules and to log in users. You will also need to set up security on the databse so users only have th appropriate access, etc.

The for designs themselves are generally based on some combination of what the interface will allow, what the users want and what kind and amount of information they are viewing and updating.

Questions about posting. See faq183-874