July 25, 2006 at 9:15 am
My boss wants me to find an ide for sql server. The scenario is that we have a user that is used to access (using linked tables) to manage on database. My boss doesnt want to use access, and wants a desktop app that connects directly to sql server using tcp/ip and is not sql server manager itself.
We had found a web based app that was perfect, but he didnt want it to be web based. The end user is not a dba, but is pretty good at access, so it would need to be a simple tool to allow this person to add/delete/update tables, do searches on columns and such, and show foreign key relations like access does. Basically a replacement for access that doesnt use odbc or is not access.
I've tried these so far:
http://www.sqlmanager.net/products/mssql/manager
http://www.sqlvisualizer.com/Default.aspx
The closest one to match what i need is sql visualizer, but would like the foriegn key lookup ability access has.
thanks,
john
July 25, 2006 at 4:46 pm
If your DB has a static IP the user can register the DB through his local copy of SQL Server (I think the client tools are free to download). And you can restrict the user with permissions.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply