Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jul 1, 2001

SQL Code Control Made Easy - Page 3

By Aaron Goldman

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.

Future Plans

I am eager to upgrade the utility and welcome suggestions from users. Email support@sqldevpro.com 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.

Resources

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.

You will also need an admin book or three, but there are no outstanding ones I know of. Try this:

Thank you.

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!

Sincerely,

Aaron Goldman
President
SQL Dev Pros, Inc.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date