Red Gate forums: SQL Data Generator 2

RE: Login failed for user when trying to open .sqlgen file

Manfred.Castro — Fri, 17 May 2013 20:09:45 GMT

You should be able to set password encrypted ="0" and then you can free type the password for the account.

<Password encrypted="0">your_unencrypted_password</Password>

RE: Mapping to an existing source doesn't work like expected

Peter13 — Fri, 17 May 2013 05:36:40 GMT

Still no indication from Red Gate when this will be fixed.

Apparently this issue is no problem for other Data Generator users, since I don't read any other complaints... Are we the only ones who use Data Generator to generate test data based on production data?

Login failed for user when trying to open .sqlgen file

debdeb75 — Thu, 16 May 2013 19:55:02 GMT

I am trying to open my Sql Data Generator file (.sqlgen). I get the error message 'Login failed for user blah' The username's password has changed so I understand why it is failing. My questions is HOW do I modify the password so that Sql Data Generator can open it?

<Username>blah</Username>
<SavePassword>True</SavePassword>
<Password encrypted="1">randomlettersandnumbers</Password>

I can modify the .sqlgen file. If I set SavePassword to False that did not allow me to open the file with Sql Data Generator. Do I have to null out the Password option as well? Or remove it all together?

Thank you,

RE: Warning about schema, duplicates may be inserted

Manfred.Castro — Tue, 14 May 2013 16:25:38 GMT

You will have to select either of the fields to be unique in order to guarantee that the generated data will satisfy the unique constraint. Without setting either of the columns to unique the generated data may not satisfy the constraint because the tool may generate data that is not unique for the combination of the two fields.

Warning about schema, duplicates may be inserted

mglimmerveen — Mon, 13 May 2013 11:20:55 GMT

Hello,

I am trying to create test data, by creating a schema based on the database schema of the TPC-C benchmark. I also added some indexes, but now I encountered a weird warning from SQL Data Generator:

Quote:

Warning: Duplicates may be inserted. Set unique is not selected for any columns in unique constraint PK_STOCK item/warehouse

This unique constraint is a composite primary key, consisting of two fields:

Code:

constraint PK_Stock PRIMARY KEY CLUSTERED(item, warehouse)

As far as I understand it, this means that the combination of the two fields is unique. So, why would I need to select unique for either of the two fields? Am I missing something, or is this a bug?

RE: WISH: It would be great to document within the project

aleezy — Mon, 29 Apr 2013 12:35:12 GMT

Nice surprise about this shorter form. Can you tell us what it is you are talking/writing about?
Has any info. about this shorter form been posted before (and i just missed it)?

RE: Data Generator Holds Connection to Database

Chris Auckland — Fri, 05 Apr 2013 10:57:48 GMT

Thanks for your post.

Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.

Are you restoring using native SQL or something else?

What does sp_who2 show you for the connection to the database you're trying to restore?

Data Generator Holds Connection to Database

rodney — Thu, 04 Apr 2013 06:21:31 GMT

I used data generator to generate some data, then wanted to restore my database to its original state. This requires exclusive access to the database, but it appears that the SQL Generator app holds its database connection, even if you close the project it still seems live until you close the whole application.

Closing and reopening the app is a work around, but is there something more obvious?

Thanks

RE: Cannot load the Backup Reader dll (see inner exception)!

sdpages — Thu, 28 Mar 2013 16:13:01 GMT

I am on windows 7 and running SQl server 2008 R2

Initially I was getting the same error message.

Looks like it worked after I created an empty database and script out all the tables that i need to mask to that new database. I then right click on the new database and open up the generator and it worked.

this was on my test environment,.

RE: Release Notes for 2.0.3?

eddie davis — Wed, 27 Mar 2013 18:37:08 GMT

Hi skling

This is a little embarrassing, sadly there are no release notes available for this minor release of SQL Data Generator.

If my memory is correct, it resolved two or three minor issues. Also integration into SSMS, where you can right click a database and select an option "populate [database name] with data" which would start up SQL Data Generator with the required connection settings.

Many Thanks
Eddie

RE: Mapping to an existing source doesn't work like expected

Peter13 — Wed, 27 Mar 2013 07:16:15 GMT

Because other visitors of this forum can't read my support ticket, I will inform them this way about our proceedings:

Red Gate has determined that the automatic column mapping functionality has disappeared between version 1 and 2 an has no idea when it will be fixed. Leaving me, of course, very disappointed. Why do you remove functionality when upgrading a product without notifying your users? The only reason I can think of is you want to sell your product "SQL Data Refresh". Which, by the way, doesn't satisfy our needs because SQL Server 2012 isn't supported.

Release Notes for 2.0.3?

skling — Tue, 26 Mar 2013 14:32:56 GMT

This is the only release notes you offer from 2.0 on: http://www.red-gate.com/supportcenter/content/SQL_Data_Generator/articles/version_2xx_SQLDataGenerator

Can you update this page or reply to this thread to give some indication of what is being done since? I just upgraded to 2.0.3 and I have no idea what is in it.

RE: Overriding Foreign Key Generator

pvearchitect — Mon, 18 Mar 2013 22:54:55 GMT

I also have a similar situation where I have an FK from a list of reference values but, due to a constraint, can only have a subset of values placed in the table. I would like to have the ability to apply a filter to the FK to restrict the generation to allowed values.

RE: WISH: It would be great to document within the project

sgehret — Thu, 07 Mar 2013 21:30:25 GMT

Hi,

Great! I really hope this gets realized as I want to document the projects I have created.

Take care,
Scott

RE: WISH: It would be great to document within the project

Manfred.Castro — Thu, 07 Mar 2013 21:29:19 GMT

I have logged this feature request for you under the internal reference number
SDG-1024