0

I need a testing framework for SQL Server 2000 (yeah, I know).

I would ideally use tSQLt with Red Gate Test but it does not work on SQL 2000 because it requires CLR (among other issues).

A lot of the info out there suggests TSQLUnit is (was?) supported for SQL Server 2000 but the versions on sourceforge all include non-supported syntax.

Specifically, the helper proc tsu_FakeTable includes this local variable:

DECLARE @cmd VARCHAR(MAX);

and I'm concerned VARCHAR(8000) is a gotcha waiting to happen.

abatishchev
  • 98,240
  • 88
  • 296
  • 433
onedaywhen
  • 55,269
  • 12
  • 100
  • 138

2 Answers2

1

Are you willing to consider an alternative framework? For example DbFit (now maintained as part of the fitSharp project), which supports SQL 2000.

Ed Harper
  • 21,127
  • 4
  • 54
  • 80
0

Oops, the procedure tsu_FakeTable is part of a suite of helper functions rather than being part of TSQLUnit itself.

onedaywhen
  • 55,269
  • 12
  • 100
  • 138
  • Which means you *can* use TSQLUnit with SQL Server 2000? – Andriy M May 18 '12 at 08:49
  • Ah, how refreshing to know! I was about to go with the saying ‘Silence gives consent’, but it is really good of you to come back and silence any doubt. :) – Andriy M May 23 '12 at 08:09