A solution - A new hotkey!
Now you can automatically 'type' the text on the clipboard. If you copy the
name of the object you want from my tool and select the appropriate starting
place in your tool, my hotkey (WindowsKey-T by default) will jump right to your
selection. This works in Visual Interdev, SourceSafe, Windows Explorer or any
other similar interface.
My tool gives you another option as well, you can choose to edit the object
right from my interface and my tool will script the object(s), save it to a file
with a '.SQL' extension and bring up your default editor. If your editor is
Visual Interdev or Query Analyzer (nee ISQL/w) you can find, edit and recompile
The hotkey can also help you when you're in your standard development
environment (mine is Visual Interdev). If you have a lot of procs referencing
other procs or you want to examine a referenced table, all you have to do is
copy the name to the clipboard, highlight the object list, and press the
hotkey. You will jump right to your target.
I just want this object from here to there.
Good change control requires a documented script for upgrades, but if you
have several development and test databases and need to move objects around, I
can do it for you. Sure you can do it in enterprise manager (beware SQL
7's nasty habit of turning tabs into single spaces), but EM won't difference
your objects beforehand, and you'll have to deal with some itty bitty
windows. It also won't search by date or pattern for you either. Suffice
it to say, I use my tool and so does everyone else who has tried it. (It
won't move the data for you, but that feature is planned.)
Why can't the same tool work for both the 6.5 and 7.0 version?
This is one of the few tools that will work with versions 6.5 and 7.0
simultaneously. There are no switches to set to change between versions,
just point and shoot. You can even compare scripts and import and export
I rebuilt and rearchitected this SQL Dev Pro to work with both
versions. I certainly hope people find it worth the effort. Going forward,
I expect to incorporate more and more SQL 7 only features, but the core will
remain dual compatible.
Data Compare and Export
SQL Dev Pro will compare the data between tables and show you
differences. The data import/export function is a planned upgrade.
I am eager to upgrade the utility and welcome suggestions from users.
Email firstname.lastname@example.org with any
comments or suggestions.
Current plans call for data import/export functionality, server and database
settings comparison and monitoring, job import export and sourcesafing, more complete
documentation, Visual Interdev Integration, and multi developer/project coordination with object groups.
People are always asking about SQL development environments and training
issues so I thought I'd voice my opinions here.
What is a truly great SQL development environment?
Visual Interdev Interdev is my unreserved recommendation. Though it lost VBA
programming and strangely its outdent going from version 1.0 to version 6.0, its
my favorite. Its code editor is quite good, and table editor is great. Its
models are great for seeing and editing a few tables at once, but it is not a
good modeling tool.
Other good tools?
Erwin is a great modeling and documentation tool, but it is so pricey and my
friends tell me that CA (which bought Platinum which bough Logic Works -- I keep
thinking of big fish eating little fish) is a killer of great software. Erwin's
strength is in modeling from concept to initial design. It is the best way
to make schema when you're making a bunch of tables at once. After that, I
prefer Visual Interdev for adding a table or column one at a time. But for
documenting, and making multiple views of the database for easier understanding
I keep using Erwin.
SQL Dev Pro is the topic of this essay, and many users find it
indispensable for differencing schema and data, scripting, SourceSafe archiving,
searching, export, and recompile.
What are the good books?
I've seen Joe Celko referred to as a SQL God. If you want to be an
advanced SQL programmer, SQL for
Smarties, is my top recommendation.
If you want to know how SQL Server works internally, and if you're working
with SQL Server you should, read Inside SQL
Server 7.0 (or 6.5) by
Ron Soukup and Kalen Delaney.
For an introduction to front end programming read Hitchhiker's
Guide to Visual Basic and SQL Server by William R. Vaughn.
If you've read or scanned this far, thanks for your interest in SQL Dev Pro.
I hope you like it. Check out the software at www.sqldevpro.com - the fully functional
lite version is FREE!
SQL Dev Pros, Inc.