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 quite seamlessly.
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 between versions.
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.
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.