Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Advice on remote connection

Author  Topic 

john777
Starting Member

1 Post

Posted - 2014-04-24 : 11:49:52
Hello
I am currently involved in the migration of data in a filemaker database to a simple one table sql database sitting on a windows 2008 server.
the database does not backend a website, it acts as a data source for an indexing engine which backends a website.
the indexing engine only interacts with the database when someone runs an update command on the server.
What I need is a way for several users here to be able to update the actual database on a daily basis.
I don't want to construct a PHP form as the powers that be are worried about sql injection attacks (rightly or wrongly), and I would have to learn PHP from scratch.
so can someone recommend any tools that allow for the updating and amending of the data remotely, preferably in a graphical a format as possible.
Many thanks for reading

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-04-28 : 01:25:05
A few different options (depending on budget and skill level)
1)Create some stored procedures
2)Use SSMS to interact - or if SSMS is not allowed , some other interface such as SQLCMD, Powershell. Note: all these tools come with Windows\SQL Server
3)Look for a web based SSMS tool

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -