Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TigerTiger
Starting Member
3 Posts |
 Posted - 2007-07-05 : 04:27:02
|
| Hi Everyone, I am doing SQL releases. what i am looking for is a kind of script validator which check for BEGIN TRANSACTION and COMMIT TRANSACTIONS and few other things may be i can add for validation.If anyone have any ideas about some tool which can validate SQL scripts it will be of great helpThanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-05 : 05:15:55
|
| Not sure I've really understood the question. Can you elaborate pls?Kristen |
 |
|
|
TigerTiger
Starting Member
3 Posts |
Posted - 2007-07-06 : 05:24:52
|
| In detail...... When i have 40 to 50 scripts to release i don't want to go through all the scripts for Standard Checks eg: All the Keywords are in UPPERCASE, All the function names are in LOWRCASE, SYNTAX in all the scripts are fine The ones which i have mentioned above are few things which the tool can check. just wondering if their is any tool that i can run my scripts through to do these checks. Many Thanks Tiger |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-07-06 : 05:50:10
|
| You can use SET PARSEONLY to just check the syntax. It won't resolve the object names though.Why are you fussed about the upper and lower case thing? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-06 : 06:42:44
|
| We create scripts as we go. So in DEV if we add a column / table etc. we script that, then we run the script against our DEV database - thus we know it works! We then run the same scripts against our QA database, and subsequently the Production databases.We use a Revision Control system to store all the source code - so that we can easily extract all source code created since the last "release". (We use SubVersion, but its largely a matter of choice)Dunno if that helps at all though?Kristen |
|
|
|
TigerTiger
Starting Member
3 Posts |
Posted - 2007-07-09 : 06:17:24
|
| Thanks for all your help guys.It didn't solve the problem. I don't think there is a tool for validating SQL script.Tiger |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-09 : 07:01:45
|
| "I don't think there is a tool for validating SQL script"My point was that if you use the scripts during development, and QA, and then again during release, you will have debugged them about as far as is possible.Having a tool that validates your SQL Scripts isn't much of a substitute for actually testing them!Kristen |
|
|
|
|
|
|
SQL Script Validator