Add data to a database, without physical access to the server machine

Question

I have two computers in a client / server architecture. The server runs SQL Server. The client has to provide an interface to insert data to this database.

I know that this can be achieved with Microsoft Access forms but I lack the time to do it. Is there any free software that can do this?

How much faster do you want it? You didn't specify the format and nature of the data? — surfasb, Sep 07 '11 at 04:44
What do you mean faster? The data will be numbers at a small range. Let's say 001-650. — py_script, Sep 07 '11 at 17:25

music2myear · Accepted Answer · 2011-09-08T14:38:00.287

2

It'll take time no matter what software you use.

You should at least be able to install the SQL Server Management Studio (if you're running Microsoft SQL Server) and use that to write a query that'll insert your required data. This program is freely available from microsoft.

UPDATE more information:

Install the Management Studio on your own computer and connect to the database(s) on the SQL server using the Studio.

Then you should be able to run queries and add/update data in the databases as you desire using the Studio.

However, if you already have Access on your computer, it will probably be a better way to do this. The Management Studio was meant as a way to manage the databases and servers, and its query capability is only incidental. Access was meant as a way to interact with the data in databases, and so lacks management function.

UPDATE instructions for inserting data using SQL Management Studio:

First, I will assume you know SQL. If you don't know SQL you should not attempt this. I will not provide actual code you can simply copy and paste into the correct field.

Second, it will be easiest if you already have the data you need to insert entered in a table with the same basic structure as the table on the SQL server you will be updating.

With the Microsoft SQL Server Management Studio installed on your computer, you will need to authenticate to the server/database, then in the Object Explorer, expand Databases.

Select the Database you wish to update, right click and select New Query. There are no wizards here. You will be presented with a blank sheet in which to write your query.

Use an INSERT or UPDATE query to add the records from the table to the database.

NOTE: This can also be done via PowerShell, which may be better if you'll need to do this process regularly. Simply create a staging database where you enter the data you'll want to insert into the database on the server, write a powershell script and save it that imports this data into the database, and run it whenever you need to.

edited Sep 08 '11 at 14:38

answered Sep 06 '11 at 20:18

music2myear

41,771

I have already done it. :) – py_script Sep 06 '11 at 20:30
Did that allow you to add data? – music2myear Sep 06 '11 at 20:54
Remotely? How? Thats my question :) – py_script Sep 07 '11 at 17:25
I still dont get it dude :s How will the "remote value" be entered to the table? All the stuff you say are correct but basics and already known/done :) – py_script Sep 07 '11 at 19:14
Umm, create table and import? Or a simple insert statement? – surfasb Sep 08 '11 at 01:19
Re-elabourate. You have data on your current client PC, and need to insert it on the server. Is the data you need to enter somewhere already or is it just written out and still need to be entered? – Canadian Luke Sep 08 '11 at 14:47
Luke, are you asking me to elaborate or peraueb1989? – music2myear Sep 08 '11 at 14:54
@Luke, I will wait for a human client to give me some instructions to enter them. So I need an interface to pass them in a user-friendly way. A good way will be php or access forms but I dont have the time to do it. I prefer something ready and more stable. – py_script Sep 09 '11 at 16:18
@music2myear I was talking to the OP but put this under the wrong comment – Canadian Luke Sep 09 '11 at 16:52
Powershell? I will take a look. So we have php forms, access forms and powershell. Thank you :) – py_script Sep 10 '11 at 13:47

Add data to a database, without physical access to the server machine

1 Answers1