DB Tools for Progress

Yahoo Archive
1
For viewing the data and structure of DB: free to use SQL squirrel

*********************
PLEASE USE 'Reply to ALL' functionality - so I don't need to search
through all new posts in Vantage group to be able to answer your
question
*********************

regards

Grzegorz Szczepański

Dnia Wed, 29 Apr 2009 21:42:06 -0000
"Brad Feazell" <Brad_feazell@...> napisał(a):

> Are there any reasonably priced tools that can be used to explore the
> structure and contents of a Progress database? Something similar to
> SQL Enterprise Manager, Visual Studio or Toad? I know that Progress
> sells OpenEdge Architect for $3,600 per user but I'm hoping to get
> something for considerably less since I'm not sure how long we'll
> need the tool.
>
> Thanks,
>
> Brad Feazell
> Dril-Quip, Inc.
>
2
Are there any reasonably priced tools that can be used to explore the structure and contents of a Progress database? Something similar to SQL Enterprise Manager, Visual Studio or Toad? I know that Progress sells OpenEdge Architect for $3,600 per user but I'm hoping to get something for considerably less since I'm not sure how long we'll need the tool.

Thanks,

Brad Feazell
Dril-Quip, Inc.
3
--- In vantage@yahoogroups.com, "Brad Feazell" <Brad_feazell@...> wrote:
>
> Are there any reasonably priced tools that can be used to explore the structure and contents of a Progress database? Something similar to SQL Enterprise Manager, Visual Studio or Toad? I know that Progress sells OpenEdge Architect for $3,600 per user but I'm hoping to get something for considerably less since I'm not sure how long we'll need the tool.
>
> Thanks,
>
> Brad Feazell
> Dril-Quip, Inc.
>
Try using Microsoft Access.
4
I'm not familiar with SQL Enterprise Manager, Visual Studio or Toad, so I'm
not sure what you need/want to do. I can however tell you what we use and
for what purposes...

We use the Vantage Data Dictionary to view table names, field names and
types and indexes. We use DB Visualizer (http://www.dbvis.com/ $150) to
view the data in tables. It allows modification as well if you are
comfortable with that and has an extensive feature set that we haven't had
time to get into. Some tables do not display because of a problem we have
not taken the time to diagnose (I think a field has data that is longer than
the SQL standard supports for that data type, but haven't called support to
confirm or find the workaround). Other than that we haven't had any
problems with it.

Good Luck,

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brad Feazell
Sent: Wednesday, April 29, 2009 5:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] DB Tools for Progress






Are there any reasonably priced tools that can be used to explore the
structure and contents of a Progress database? Something similar to SQL
Enterprise Manager, Visual Studio or Toad? I know that Progress sells
OpenEdge Architect for $3,600 per user but I'm hoping to get something for
considerably less since I'm not sure how long we'll need the tool.

Thanks,

Brad Feazell
Dril-Quip, Inc.



.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msgId=7
7365/stime=1241041364/nc1=1/nc2=2/nc3=3>




[Non-text portions of this message have been removed]
5
If you go to the full Data Dictionary and not the Viewer then you can change the SQL default data length that is passed for each field.Â
Â
Use the Adjust Field Width dialog box to adjust the SQL-92 field width property. If you do not adjust the property, the SQL-92 client uses the default width. To access this dialog box, choose Options>Adjust Field Width from the main menu.
Â
If you want to try it on a test database and need some help then contact me offline.
It is not hard at all but be carefull not to change anything else in there. I would do it on the test database 1st.
Â
The default is double the progress data format. I have seen people cut and paste 10,000 characters in a 1,000 character comment field in version 6.1
In Version 8 and above it should be harder for them to enter more data than the format is set up for due to going through the .net user framework.

--- On Thu, 4/30/09, Dan Snyder <dan.snyder@...> wrote:

From: Dan Snyder <dan.snyder@...>
Subject: RE: [Vantage] DB Tools for Progress
To: vantage@yahoogroups.com
Date: Thursday, April 30, 2009, 2:49 PM









I'm not familiar with SQL Enterprise Manager, Visual Studio or Toad, so I'm
not sure what you need/want to do. I can however tell you what we use and
for what purposes...

We use the Vantage Data Dictionary to view table names, field names and
types and indexes. We use DB Visualizer (http://www.dbvis com/ $150) to
view the data in tables. It allows modification as well if you are
comfortable with that and has an extensive feature set that we haven't had
time to get into. Some tables do not display because of a problem we have
not taken the time to diagnose (I think a field has data that is longer than
the SQL standard supports for that data type, but haven't called support to
confirm or find the workaround). Other than that we haven't had any
problems with it.

Good Luck,

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Brad Feazell
Sent: Wednesday, April 29, 2009 5:42 PM
To: vantage@yahoogroups .com
Subject: [Vantage] DB Tools for Progress

Are there any reasonably priced tools that can be used to explore the
structure and contents of a Progress database? Something similar to SQL
Enterprise Manager, Visual Studio or Toad? I know that Progress sells
OpenEdge Architect for $3,600 per user but I'm hoping to get something for
considerably less since I'm not sure how long we'll need the tool.

Thanks,

Brad Feazell
Dril-Quip, Inc.

.

<http://geo.yahoo com/serv? s=97359714/ grpId=20369/ grpspId=17050071 81/msgId= 7
7365/stime=12410413 64/nc1=1/ nc2=2/nc3= 3>

[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]
6
I also use MS Access. It does have limitations and issues with some indexed tables (such as customer), but generally works well to browse data and work on simple queries.

The DB Visualizer that Dan posted looks interesting though and about the same price as MS Access.
7
Could someone shed some light on use of JDBC with the DB Visualizer
tool?



It appears there are two approaches that could be taken using a native
JDBC driver or using a JDBC to ODBC bridge.



Does anyone know if the JDBC driver is available and packaged with
Vantage for free or is this something that must be purchased separately
from Progress?



Even if you can get it does this then bypass the data dictionary and
render this approach impractical?



Thanks in advance!



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
8
> Does anyone know if the JDBC driver is available and packaged with
> Vantage for free or is this something that must be purchased separately
> from Progress?

It's in the Java folder in your OpenEdge installation direction.

> Even if you can get it does this then bypass the data dictionary and
> render this approach impractical?

I've used Squirrel SQL to browse data. You can see whatever the login you
use allows you to see. Regular caveats apply about updating, etc. since
you're bypassing all business object logic.

Mark W.