Solved

SQL Query Validator for SQL Server

Posted on 2014-02-21
4
384 Views
Last Modified: 2014-03-21
Hi Experts,

     I am looking for a SQL query validator (free or paid) for SQL Server/SQL Management Studio.  Basically I am looking for a tool that makes sure that all referenced objects (tables (both actual and temp), columns, functions, sprocs, user defined types, etc.) in every sproc/function/etc. exist in the database.

     We have been wasting a lot of time lately due to people removing/changing the spelling of objects and we don't find out about it for a while.  Is there a tool that you all know of that I could run on a database/or at least a script and validate it against an existing database to verify the above things?  I need the tool to work on MS SQL Server '08R2 or higher

Thanks!
0
Comment
Question by:axnst2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 250 total points
ID: 39878007
http://download.red-gate.com/HelpPDF/DatabaseUnitTestingWithRedGateSQLTools.pdf

Looks like redgate's Sql tools may be a bit of overkill, but depending on your project size may also help you out.  I wouldn't say it does the validation per say, but it can use the data generator to fire off the stored procs .  . . and even gives you validation against it.
0
 

Author Comment

by:axnst2
ID: 39878087
Yes, I am not looking to spend days on setting this up.  I'm just looking for a simple like 'Check' button
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 39878103
I had the same problem in the past. I solved half of it. Check http://emoreau.com/Entries/Articles/2010/02/Validating-database-objects.aspx
0
 

Author Closing Comment

by:axnst2
ID: 39945461
Thanks
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question