Activity overview
Latest activity by DAndres109
JOIN conditions
Hi,
This one is tough for me to describe, so I'll just give an example:
Given:
Table A
Table B with foreign key to Table A
Table C with foreign key to Table A
When I write the following query:
SELE...
Hi,
What if you don't want certain columns to be used for comparison purposes, but you would still like for them to be inserted if a row doesn't match for other reasons?
Is this possible using SQL Data Compare 6.1.1.308?
Thanks,
David Andres / comments
Hi,
What if you don't want certain columns to be used for comparison purposes, but you would still like for them to be inserted if a row doesn't match for other reasons?
Is this possible using SQL ...
Brian,
Can you confirm if the keys are dropped and recreated for ALL dependent objects or only for those that are explicitly included in the sync by the user?
Thanks,
David / comments
Brian,
Can you confirm if the keys are dropped and recreated for ALL dependent objects or only for those that are explicitly included in the sync by the user?
Thanks,
David
Ben,
I agree that there's no "correct" solution to assigning weights. The only thing that comes to mind is if there are 100 or fewer constraints, then at least you can do an average, where the first option is modified to sum up to 100 percent.
What do you think?
David / comments
Ben,
I agree that there's no "correct" solution to assigning weights. The only thing that comes to mind is if there are 100 or fewer constraints, then at least you can do an average, where the fir...
Ben,
That's a fair summary of my needs at this point.
Essentially, each row could have a set of variables (randomly valued) that can be referred to by expressions for selected columns, and each column can refer to other columns within the same row (to ensure that the figures match up).
I recently completed a project where I needed to ensure the following:
1. Given a randomly generated total Total T, calculate Quantity X as a percentage (between 0 and 20) of that total.
2. Quantity X is really the end result of a formula involving four table columns (referred to as A, B, C, and D), so I wanted to be able to distribute randomly across these four columns while still maintaining the rule that they must add up to Quantity X.
In this scenario, I first calculated the percentage I needed to obtain Quantity X, and calculated the other values based on random portions of this percent. For example, given:
X %: 15
A %: Random(0, X%)
B %: Random(0, X% - A%)
C %: Random(0, X% - A% - B%)
D %: X% - A% - B% - C%
All of which are then multiplied by Total T to get the values I need.
Hopefully, this can be more generalized then what is described here. I think it is complicated, but seems useful to be able to do for particularly hairy test-data-generation needs.
Thanks,
David / comments
Ben,
That's a fair summary of my needs at this point.
Essentially, each row could have a set of variables (randomly valued) that can be referred to by expressions for selected columns, and each col...
Ben,
You've answered my basic concern, that rows are added in a smart way.
I can't think of a specific need to alter the order of generation if it already takes into account dependency.
Thanks,
David / comments
Ben,
You've answered my basic concern, that rows are added in a smart way.
I can't think of a specific need to alter the order of generation if it already takes into account dependency.
Thanks,
David
Feature Request: Automatically populate "Weighted List"
Hi,
In some cases, a Check constraint may exists that limits a field to only a handful of values.
Is there any way for the Data Generator to automatically pick up and list these values during these...
Oddball Feature Request: Generation of Temporary Column, etc
Hi,
Consider the following schema:
Table A:
Col1: int
Col2: int
Col3: int
Col4: int
Total: int
I need to be able to ensure the following invariant is true for a each generated row:
Total = random(m...
Feature Request: Option to purge dependencies
Hi,
When synchronizing between source and target tables, I believe that it is possible for the operation to fail if target records exist that cause foreign key violations.
Can you add an option tha...
Order of data generation and dependency
Hi,
Is it possible to configure the table order that the data generation operation should use? There are some tables I would prefer to have populated before others.
Thanks,
David Andres