I have a progress database that I need to connect to. What is their equivalent to the SQL Server Management Studio?
The server appears to be Progress OpenEdge 10.1
+1
A:
It depends a bit on how deep you really want to go but "OpenEdge Management" is probably the closest.
If you just need to start & stop the db and take care of routine maintenance you don't need OE Management -- all of that stuff is "in the box" either via "Progress Explorer" or scripting (depending on your taste) and a few utility programs.
To just browse the SQL any standard SQL tool will do. "Squirrel" is a popular option.
OpenEdge does contain a command line tool "SQL Explorer" that you could also use -- it is installed in %DLC%\bin\sqlexp.exe
Tom Bascom
2010-03-28 10:57:44
What I'm looking for is something that will let me connect to the database, view the table structure, and, possibly, run some sql queries.
Chris Lively
2010-03-28 18:21:21
Close enough. Thanks. I ended up configuring a sql server to have a linked server connection to the progress db. This enabled me to query the sys tables for structure and to run my queries. It worked well enough to complete the project
Chris Lively
2010-09-13 14:52:11