Use TST to test remotely

Dec 16, 2011 at 10:55 AM

I currently uses TST and would like to run TST test on my QA database server, that are testing on either the development or production servers. My attempts to link servers and then run the query have failed. Able to query linked database servers, however within TST server will return invalid operation and that transaction is not allowed.

Has anybody been able to use alternatives methods, such as ODBC or native client connections?

Has anybody been able to create extentsion that will enable TST to execute test remotely?

Dec 17, 2011 at 11:07 PM
Edited Dec 18, 2011 at 3:06 AM

Hello oorupabo,

The typical use of TST is to have both the tested database and the TST database on the development environment (or on some test environment). You should not run it on a production environment.
Keep in mind that TST is used to do code validation and not data validation. Code validation means to exercise the code in various scenarios. These scenarios could push the code in some corner cases that may or may not happen in the real use but which are deemed important test wise. Once you tested these scenarios on a development/test machine there is no need to run the same tests in a production environment. Frankly, I would never touch a real production database with tests that are supposed to exercise the code in test scenarios. I strongly recommend you do not do that. However, on the production environment you may want to run data validation. That means doing validation on the existing production data, validation that goes beyond what can be achieved with referential integrity. For data validation in a production environment I would recommend different techniques than using TST. Typically you will have some scheduled jobs that when detecting invalid data will try to auto-correct or maybe just to notify (via email or other means) the admin.

Having all these said, I did not test TST in a scenario involving linked servers. You could try these links:
http://social.msdn.microsoft.com/Forums/en-NZ/sqldatabaseengine/thread/523116d4-4c8e-43a8-abf4-e705ffaa68c8
http://sqlservermemories.blogspot.com/
http://36chambers.wordpress.com/2011/04/08/msdtc-no-transaction-is-active/

Let me know more about how you structure/use your environment.