| Author |
Topic |
|
kbdrand
Starting Member
14 Posts |
 Posted - 2002-11-20 : 11:04:05
|
| Forgive my ignorance, but is there a tool out there, either included with SQL Server (version 7 or 2000), that will let you do table creation and editing in a GUI environment as opposed to T-SQL statements? I've been creating my tables with T-SQL statements, but I have some developers that need to start creating their own tables, but they don't know SQL that well. |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-20 : 11:14:57
|
| Enterprise Manager would be the first thing that comes to mind. It's included in SQL server, all versions (except MSDE).There are of course third party tools as well, but I haven't seen any which is good enough to recommend.Edited by - andraax on 11/20/2002 11:15:19 |
 |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-11-20 : 11:15:27
|
| yes, Enterprise ManagerJustinDammit! I've been sniped.Edited by - justinbigelow on 11/20/2002 11:16:59 |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-20 : 11:17:30
|
| Access 2000/2002 access data project (.adp) and Visual Studio .NET are also good.Edited by - ValterBorges on 11/20/2002 11:18:50 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-20 : 11:19:03
|
I'll be shot for suggesting this, but Enterprise Manager has those features. However, unless you are diligent about setting up individual logins for the developers and granting the proper permissions, they will be able to do pretty much anything to the server with Enterprise Manager.Frankly, CREATE TABLE and ALTER TABLE are pretty simple statements to master...I'd be extremely hesitant to let someone have access to a server if they can't handle it...and I definitely wouldn't want them to use Enterprise Manager either.Might also want to take a look at the Tools section:http://www.sqlteam.com/FilterTopics.asp?TopicID=122 Edited by - robvolk on 11/20/2002 11:19:50 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-20 : 12:23:20
|
| Expecting the question'How do I detect changes to table structure'soon.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-11-20 : 18:02:07
|
quote:
but I have some developers that need to start creating their own tables, but they don't know SQL that well.
That comment makes me agree with nr's post. I would suggest that if they don't know SQL that well then you don't let them do it. What you will end up with is a mess of a database, with poor naming standards, bad design and lots of duplicated, redundant and non-normalised data.Perhaps you need to appoint someone in a DBA or DBD (databse developer) type role. The developers can come to them with a proposed table structure, then both can sit down and analyse the design and the knowledgable person can implement it.If you get that sort of a process involved, before too long your developers will understand databases better, know the issues and learn the sql needed.Your databases will be better for it, and your developers will be better for it.Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-20 : 18:20:15
|
| Merkin is absolutely correct. The tool that you are looking for is Enterprise Manager, but someone who doesn't know SQL shouldn't be using it. Do these developers at least know how to design a good database? If they don't, then they shouldn't be entering this realm. You're going to end up with a bad design that does not perform or work well. |
|
|
|
|
Is there a good Table editor/creation tool ?