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 |
|
jodelvalle
Starting Member
4 Posts |
 Posted - 2009-09-16 : 16:18:39
|
| Hi,Can somebody point me on the right direction? I need a script that will test SQL Server functionality (Create DB, create tb, insert, delete, select, etc.) I want to run the script after any major SQL update (SP,etc.). Any help will be appreciated.PS. I am new to SQL. Thanks.JD |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-09-16 : 21:32:58
|
| Hi, Your script will need to be specific to your database. I can't see any point in verifying that a CREATE TABLE statement will work after a service pack install. MS's quality control is not THAT bad....If it was me, I would have a dev/UAT database set up with all db objects and DTS package (import/export routines) and then use a testing application to execute some key processes and check the results. It's not a trivial task....I hope this helps.Tim |
 |
|
|
jodelvalle
Starting Member
4 Posts |
Posted - 2009-09-17 : 08:29:59
|
| Hey Timmy,I understand your point. I do not really need anything specific to my database. I have a virtual machine with SQL server 2005 installed on it. I keep this VM updated to match what we have on production. Currently there are no DBs on the test server. I would like to set this up more like a CYI type of thing. The script can create the db, create table, insert, delete, update, drop, etc. just test the functionality of the server. I just want to show, if asked, that I did my diligence to ensure that any new update/SP will not break the server.I know MS QA should not be that bad, but I am just following Murphy's Law. If you or anyone reading this post can create such script, I will really appreciate the help.Regards,JD |
|
|
|
april198474
Starting Member
11 Posts |
Posted - 2009-09-22 : 00:47:38
|
quote:
Originally posted by jodelvalle
Hi,Can somebody point me on the right direction? I need a script that will test SQL Server functionality (Create DB, create tb, insert, delete, select, etc.) I want to run the script after any major SQL update (SP,etc.). Any help will be appreciated.PS. I am new to SQL. Thanks.JD
I will develop a program to check the result too. |
|
|
|
jodelvalle
Starting Member
4 Posts |
Posted - 2009-09-22 : 14:19:24
|
Hi,Are you saying you will develop the script?quote:
Originally posted by april198474
quote:
Originally posted by jodelvalle
Hi,Can somebody point me on the right direction? I need a script that will test SQL Server functionality (Create DB, create tb, insert, delete, select, etc.) I want to run the script after any major SQL update (SP,etc.). Any help will be appreciated.PS. I am new to SQL. Thanks.JD
I will develop a program to check the result too. _____________________april198474 www.comm100.com
|
|
|
|
rpcasey001
Starting Member
1 Post |
Posted - 2009-09-22 : 16:41:52
|
| Have you thought of using PowerShell and SMO?Ryan P. Casey • www.R-P-C-Group.com |
|
|
|
jodelvalle
Starting Member
4 Posts |
Posted - 2009-09-23 : 13:24:18
|
I have not worked with neither one. We are small company and the sql person is not putting a priority to create a custom script so us, the Sys Admins, can test the functionality of the SQL server after installing major upgrades.quote:
Originally posted by rpcasey001
Have you thought of using PowerShell and SMO?Ryan P. Casey • www.R-P-C-Group.com
|
|
|
|
|
|
|
|
|
Need script to test SQL Server functionality