What SQL Editor do you use?

[SteelValor]

I'm curious if anyone acutally uses something just for sql. I currently use the stuff from MySQL, Homesite+, PHPDesigner, notepad, etc. I'm gonna try out DBWrench and DB Designer 4. I'm looking for autocompletion and color coding.

[pos]

i've always been a fan of PHP Designer

[Direhit]

I deal with PostgreSQL, MS SQL, MySQL and occasionally Oracle and I don't think I have ever used anything other then notepad to modify SQL structure files.

[SteelValor]

Anyone have anything that can open a 3gig sql file? (out of memory)

[SteelValor]

WordPad w/ 4096mb VIrtual Memory and a 20 minute wait


wow

[Mulchman MM]

rofl

[SteelValor]

WordPad died at 27 minutes :/ BUT Notepad++ wins with a 1 minute open and a find/replace :D

[SteelValor]

Ok none of them can open this puppy on my pos workstation. :/

[Exe]

I use Golden32 by Benthic Software.
I occassionally use TOra as well.

Edit... I reread the thread and see that you are trying to edit a 3GB SQL file - I'm not sure either of these editors would enable you to edit a 3GB file.
Question... how the hell do you end up with 3GB worth of SQL in a single file ?? What is it that you are trying to do ? If its a mass edit, consider a shell script (i.e. Linux/Unix).

[SteelValor]

We're trying to host an asp/mssql project. We used Navicat to moves the db to MySQL only the guys who did it changed the tablenames and I need to change them back and all I have to work with is the sql which happens to have 3gig of data in it. I did just get an idea though. I could export the MySQL db without the data edit that and then use that to rebuild the schema. Then ... aww snap :/ nm

[DaRkK]

any of u php guys wanna make $$? i need my portfolio coded

pretty much i wanted a page where i could select a file, chose its category and then upload it.

and then that file is automatically synchronized into the category's page ie

www.darkk.org

i want a page where i can go, select a file ie darkksig.jpg then chose whether its a sig or a banner or a layout or w.e and hit upload and it uploads to a specific page

then i could go to my site again go to work and select signatures and viola it shows the sig on that page!!


how much would something like that cost?

feel free to pm me or drop me an e-mail at interp1@gmail.com


thanks

[SteelValor]

Wordpress.org

[thrash_head]

wordpress is great if you know someone that can skinn it. I've seen some very nice skins for WP.

[SteelValor]

Back on topic: fug it we decided just to put up a ms sql server :/

[DaRkK]

will anyone be willing to help me out a little on this wordpress?

i have thursdays and fridays off work so sometime on those days if we could chat and stuff that would be great, please leave me a way to contact u irc/aim yahoo w.e

[unix_yoda]

Try textpad, handles larger files much better than notepad/wordpad, it's amazingly efficient but as someone mentioned a 3 GIG db is pretty massive and if you have a lot of consistant or patterned editing to do you really should consider using a script of some type or you might be awhile :)

[Exe]

For a file of that size a nice unix/linux shell script would work well - I write awk scripts all the time for text manipulation. It would be pretty easy to write a script to make a mass change to a large file.

[SteelValor]

I never considerd a script to re-write a script, but it's not needed now anyways.
You did peak my interest though and I just downloaded xampp :D

[Sutterkane]

I generally use gfx isql that my office has. It works with sql and oracle and is preinstalled on my laptop