InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:45:04 GMT20http://www.sqlservercentral.com/Forums/Topic1183878-2838-1.aspxI have source side stored procedure.Using which i need to do analysis and write test cases.In the stored procedure , they are updating data after wrting the stored procedure.Do any one know how to write testcases for update statments.KomalFri, 30 Sep 2011 12:18:17 GMTkomal145http://www.sqlservercentral.com/Forums/Topic1151002-2838-1.aspxIs anyone performing load testing and if so, how are you doing it?Fri, 29 Jul 2011 08:40:50 GMTEd.Watson aka SQLGatorhttp://www.sqlservercentral.com/Forums/Topic1100571-2838-1.aspxI recently read Solomon Rutzky's article on DBFit (http://www.sqlservercentral.com/articles/Testing/64636/) and I've been working with it. Once I get past a few of the gotchas such as needing to use True\False in the DBFit code where SQL Server expects 0\1 for bit values it's a nice tool.I was wondering if there are best practices for use of the tool or even for automated database testing in general? For example, the article talks about creating objects (tables, procs, etc) on the fly so they can be rolled back. That's a great concept but I'm running into problems implementing it. For example, I comment my procs so I can remember just what the heck I was doing but double dashes won't work when creating the proc from DBFit. The simple answer is to take out comments and such in the DBFit html but then you are testing something other than what you wrote or will put into production. Also, you have to make updates in DBFit when you update your scripts, etc. Too much room for error in either screwing up a copy\paste or forgetting to copy in the change.I'm considering maintaining the database by running the scripts using SQLCMD Mode from SSMS then handing over the DBFit html to the testers. That separates the database maintenance from the testing while still being able to build the database to a known state. The maintenance scripts and testing html would be stored in the same place in source control and checked out all at once when needed.Does anyone have any words of wisdom on the subject?Thanks.DonThu, 28 Apr 2011 13:59:30 GMTDonaldWhttp://www.sqlservercentral.com/Forums/Topic1077601-2838-1.aspxHello All, I need to test the working of few SQL Server related applications on Windows 7 OS for my organization.The list of applications is given below. Can anyone please advice me on what parameters and modes should I test the applications so as to get good test plans for these applications. I have not tried anything like before so trying to seek as mush help as possible on this. :DBArtisan 8.7.1DB Change Manager XERedGate SQL Backup 6.2Erwin Data Modeler 4.1 SP3Erwin Model Navigator 4.1 SP3Rapid SQL XEDB Visualizer 7.1.4Thanks for any suggestions that you have.Mon, 14 Mar 2011 03:36:45 GMTrahulr.sharmahttp://www.sqlservercentral.com/Forums/Topic1094724-2838-1.aspxHi friends,Is there any testing tool available for the testing of SQL Stored procedures/functions? . Like the Nunit testing , NAND for .Net code I'm looking for some testing tool for SQL.Thanks in advance.Sun, 17 Apr 2011 23:33:01 GMTonly4mithunchttp://www.sqlservercentral.com/Forums/Topic1094897-2838-1.aspxI would like to know the testing approach for sql sever upgrade 2000 to 2008 . Does anybody has any idea??Mon, 18 Apr 2011 07:07:52 GMTnharanhttp://www.sqlservercentral.com/Forums/Topic1063959-2838-1.aspxguys do you know how to import data from excel 2010 to MS Sql 9.0? Should that need an SSIS or some DTS?help me please.. thanks! :DMon, 14 Feb 2011 19:25:22 GMTa.campos132http://www.sqlservercentral.com/Forums/Topic1070758-2838-1.aspxHi,I've loaded a few hundred XML files into a SQL Server 2008 DB and need to show that the data was accurately replicated.I'd like to take 10% of each table (each XML files corresponds to a table) and check them against the XML file. Or vice versa, it doesn't really matter.It is easy to select 10% of each table at random, but does anyone have an idea on how to check it against the XML files?Thanks in advance.Mon, 28 Feb 2011 12:32:10 GMTiDamixhttp://www.sqlservercentral.com/Forums/Topic1068913-2838-1.aspxOur current setup is configured where local data servers are used to directly FTP the respective databases housed on that server to production servers. What I want to investigate is the processing impact of FTP'ing on the server while databases are running (and vice-versa) - as there may need to be a business case put forward to alter the current arrangement. While I have seen, VBS scripts to track CPU load, I want to have an understanding of all factors - CPU load, RAM and upload bandwidth? Are there any standardised rules-of-thumb on how to monitor these? Presuambly, I'll need to monitor all factors twice, once sans FTP, then a DB run while FTP'ing?Thanks.RobThu, 24 Feb 2011 07:02:20 GMTrobertprice45