Posts
Sort by recent activity
Issue when synchronizing Trigger in a diffirent schema
I have trigger in table and table is in not in a defult schema. I have create trigger using
CREATE TRIGGER trgname ON TableName ...
Normally I won't specify the schema name as schema will be create...
Projects List
I feel it is much better to if you can retain the list of projects in the product. We will nto have huge number of projects.
List of products will give you easy access to projects
Fast Synchronizing
Everytime, when you wanted to a syncronise you need to pass through 3-4 clicks in the wizard.
Instead, if there is a option saying fast syncronizing, it will take previous syncronizing option and d...
Syncronizing only the DML triggers
Is it possibel to syncronize only the trigger i mean DML trigger.
I have table in the developement which i have done several chages to it structure. I have done some modifications to the trigger of...
Edit Filter Rules
This is a really cool feature where you have the option of filtering objects by their names or their schema.
however, in the UI of the filter rule windows, there is a small issue.
outline of drop d...
Creating email address
I had few issues with creating email addresses. I set ($[FirstName])(.)($[Lastname])@(somewhere.com) regular expression to the email address. I cannot set unique column on to email and it gives me ...
Ignore columns
Currently you have to include all the columns. For example, I do not need Active column to be inserted as it has a default value of Y.
Column expressions
Column expressions are not possible. For example, I have a commission column which is 0.1 from salary column. Only possible way of doing this is create a computed column from SQL Server , generate ...
VB functions
It will be better to simple vb options like, left,right,lower,upper,mid to ease data generations. If I won’t to generate email addresses using firstname and last name, this will be a handy option...
Case of the check constraints
SQL Data generator treats check constraints most of the time. However, there was one occasion in which it does not treat. This is due to a bug in the SQL Data Generator. Problem here is that column...