CODEWITHSUNDEEP
t-sqlunit-testingblackfish
rozza
rozza

Reputation: 1016

How compatible is Blackfish database with TSQL?

I'm using a sqlServer database that has stored procedures, and I want to use an in-memory database to unit test my code.

I've looked at a few - including VistaDB which looks amazing but expensive - and Blackfish seems to be the only possiblity so far. Before using it though i'd like to know exactly how compatible it is with TSQL - obviously if I have a lot of existing stored procedures these will use TSQL, so it's important that the in-memory db I use can handle this.

Thanks

Upvotes: 0

Views: 131

Answers (1)

HeavenCore
HeavenCore

Reputation: 7683

Short Answer: Not Very

Long Answer:

Whilst Blackfish is SQL-92 compliant, you’re bound to run into stuff that worked on your T-SQL database that won’t work on BlackFish.

I'd strongly recommend SQL Server Compact 4.0 (or Express at a crunch), Compact can be easily bundled, has a tiny footprint (3mb installer? [18mb on disk ish]).

For instance, T-SQL Flow control might differ to Blackfish flow control - not really relevant for selects, inserts & updates etc, but if you have T-SQL logic gates in stored procedures, i don’t think these will port to Blackfish? Blackfish supports stored procedures, but they are compiled in other native languages (Delphi mainly). Good example from the documentation:

http://docs.embarcadero.com/products/rad_studio/delphiAndcpp2009/HelpUpdate2/EN/html/bfsql/storedprocedures_xml.html

Very different from the T-SQL procedures used in MS SQL

Upvotes: 1

Related Questions