Any users of FireDAC TFDScript out there?

Any users of FireDAC TFDScript out there?

Scripts produced by ApexSQL Diff, which runs fine in SQL Server Management Studio, fail when run from a TFDScript.  I am trying to figure out if it is options related, or if it is an implementation problem.

Problem 1: Transaction handing causes an error:  

Exception class EMSSQLNativeException with message ‘[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back.’. 

Problem 2: If I remove the begin tran at line 38/39 and reduce the script to only contain the create table part – it still fails silently. The spool output shows no errors, nor does any errors show in the FireDAC Monitor.  And yet – no table is created.

I also suspect that multiline /* block comments */ confuse the script analyzer.

Suggestions, anyone, particularly for Problem 2?

   

http://pastebin.com/dzR8T6fC

3 thoughts on “Any users of FireDAC TFDScript out there?

Leave a Reply