SQL Applications...

rich_g85

rich_g85

rich_g85

Associate
Joined
12 Jun 2003
Posts
2,033
Location
Either Tonbridge or Biggin Hill
Hi all,
Just curious to see what applications you use to maintain your SQL databases at work (or at home!)

I use a combination of SQL Advantage and Sybase PowerBuilder. I've only just started learning the basics so Advantage is ideal for simple SELECTs & UPDATEs.

If anyone knows of any good online SQL guides that would be good too.... :)
 
Hi Mate,

You will probably best asking this in HTML, Graphics & Programming.

Cheers,

TrUz
 
What exactly do you mean by 'maintain your SQL databases'?

We use Oracle 9i at work and use a combination of SQL*Plus and TOAD to do development and administration.

I'm currently in the process of getting 10g R2 set up on a Linux box at home.
 
Code: 
root@abox [~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.

mysql>
:p :D

But also MySQL Administrator and phpmyadmin.
 
I use SQL Enterprise Manager mainly for quick queries / maintenance stuff, sometimes Query Analyser for testing stored procs / larger queries, on MS SQL 2000 databases.
 
Hi,

I use Ingres at work and home. To run SQL I normally put the SQL into scripts and run these so they can be repeated. For one off pieces of SQL I use the supplied command line tools (ISQL and QBF).

I do front-end development using OpenROAD (a 4GL quite similar to PowerBuilder but which is showing it's age somewhat), Perl/Tk and Java.

Jim
 
caff said:
I use SQL Enterprise Manager mainly for quick queries / maintenance stuff, sometimes Query Analyser for testing stored procs / larger queries, on MS SQL 2000 databases.
Click to expand...

I've replaced this at work with SQL Server Management Studio (SQL 2005) - 'tis like Query Analyser and Enterprise Manager, but in one handy package. Much better IMO.

At home I use the Express Edition of SQL Server and Management Studio
 
pjt@stimpy:/home/pjt/>sqlplus username/password@sid
SQL*Plus: Release 8.0.6.0.0 - Production on Tue Jun 6 09:06:59 2006
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
SQL>
 
You must log in or register to reply here.
Back
Top Bottom