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.
| Author |
Topic |
|
john777
Starting Member
1 Post |
 Posted - 2014-04-24 : 11:49:52
|
| HelloI 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 procedures2)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 toolJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Advice on remote connection