SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Advice on remote connection
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

john777
Starting Member

United Kingdom
1 Posts

Posted - 04/24/2014 :  11:49:52  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2067 Posts

Posted - 04/28/2014 :  01:25:05  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000