I'm trying to set a column (bit) with the opposite of another one (bit, too) of the same table.
when one is true, the other has to be false and vice-versa.

The only choice - in my opinion - is to use a Python script.

I'm not an expert of this language, and I'm wondering if it si possible to use the value of other column in my code (as it could be done with Regexp generator : $[columnName]...)

Constraint : it is not possible to use an SQL Statement because an additional connection has to be defined in that case ; and I want to target any server/DB with only changing the connection at Project level.

I have a newer build that works with SQL Data Generator v2; if you email me, I can send it to you so you don't have to mess around with the v1 version Ben did so long ago that is not working with the current build.

The Ruby Generator does not seem to work. It does not show as an option in the column generation settings. The old one shows up, but causes an error as expected. I just unzipped and put the files in the Generator directory then started the application... Am I doing something wrong? Thank you!

Hi, I downloaded the IronRuby generator for SQL Data Generator 2.0 that Brian posted. But I don't know how to get it to show in the tool. I am evaluating this tool and the version is 2.0.3.1. I unzipped the dll files and added them to the Generator directory. But Ruby is not an option anywhere within the application.

The Ruby generator had to be rebuilt for every version of SDG, so I believe the DLL references need to be updated and the project recompiled. I think the source code is included, so you can do this. However, if you need me to look into it, I may be ~1-3 days before I can get to it.

Just to manage expectations, the Ruby Generator is unsupported and not a part of the SQL Data Generator software package. It's something I can do in my spare time.

I don't think you need to spend any time on it unless you think it would benefit the SDG user community at large. We are going to purchase this tool anyway and I am done with my testing.

The source code was not in the zip file. Just the .dll files. As a company, I think we would be interested in getting a working version of IronRuby, though, because we really have big need to reference other fields in the same row. Right now, we are doing all that kind of work in After scripts.

However, since Ben built this against an older version of MS DLR, I had to custom-build the older versions of MS-DLR, so if you wanted to recompile, you would have to replace references to the Microsoft.Scripting assemblies with the "Ruby" versions contained in the ZIP.