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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

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

Starting Member

United Kingdom
1 Posts

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

Flowing Fount of Yak Knowledge

United Kingdom
2179 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
Go to Top of Page
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000