exhaust unique data first + sdk

Hi ,

I have a couple of questions regarding the data generator.

1) When I generate data using a regular expression, I get duplicate results before all permutations are exhausted. For example, I have a regular expression (Joe|Jane...) (Blog|Bleg....) with four names in each. This should result in 16 unique permutations. However, if I generate 16 rows of test data, there are duplicates. From searching the boards, it seems you can't generate RegEx data for a 'unique' column so is there a way around this problem?

2) When generating data, the data is immediately outputted to the database. Is there a way to reroute this data to another source (such as a text document) instead? Could this be done by using the Visual Studio SDK?

Thanks for any help

[789 byte] By [RegX] at [2008-1-10]
# 1

1) Correct, right now the RegExString generator does not generare unique values, this functionality has been added to Visual Studio 2008

2) Sorry this is not possible we are looking at adding this for the Visual Studio "Rosario" release.

-GertD

GertDrapers-MSFT at 2007-10-3 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

Thank you. Looking forward to seeing the future of data generation in VS.

RegX at 2007-10-3 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 3

Just a follow up queston. Are there any provisional release dates for either VS2008 DBPRO or the Rosario release? As far I'm aware, there is no DB Pro module for VS2008 beta 2. I'd like to try and use the new features (even if they're in beta mode) as soon as possible.

Thanks

RegX at 2007-10-3 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 4

DBPro is part of VS2008 VSTS beta 2, it is based on Service Release 1 + additional bug fix functionality.

-GertD

GertDrapers-MSFT at 2007-10-3 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 5

Ah, perfect. Thank you Gert!

RegX at 2007-10-3 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified