Jan 07 2008

Initial support for SqlServer 2000 in DbFit

Published by gojko at 10:18 pm under dbfit

Great news – SQLServer 2000 is now supported in DbFit. The only limitation, compared to Sql Server 2005, is that tables and procedures must be fully qualified (defined as schema.name), if there is an object of the same name in the current user’s schema and in dbo. The next official release will include sql server support — until then, you can download the binaries from Sourceforge: dbfit-dotnet-20080107.zip

the complete package, with acceptance tests, can also be downloaded from here: dbfit-complete-20080107.zip

For sqlserver 2000, use dbfit.SqlServer2000Test instead of dbfit.SqlServerTest.

Many thanks to Oscar Centeno for his help on implementing and testing support for Sql Server


Get notified when I post something new - subscribe via RSS or Twitter!

2 responses so far

2 Responses to “Initial support for SqlServer 2000 in DbFit”

  1. # Tom Ratnaon 09 Jan 2008 at 4:06 am

    dbfit 0.93 and 2008-01-07 code do not accept fully qualified(prefixed by schema name) [table|procedure|function} names when used with MS SQL 2005. Throws an exception System.ApplicationException: Cannpt read columns/parameters for object when calling
    !|Execute Procedure|dbo.udf_ConcatenateString|
    Works fine with:
    !|Execute Procedure|udf_ConcatenateString|

    SQL 2005 best practice is for use of schema prefix rather than the default schema

  2. # gojkoon 09 Jan 2008 at 10:09 pm

    Hi Tom,

    thanks for this – I’ve fixed the problem, you can download the build from Sourceforge. It will be included in the next regular release.

Trackback URI | Comments RSS

Leave a Reply