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?