Toad World® Forums

Strange problem with Data Generator

I use Toad for SQL Server 6.8.1.204 (32 bit).

I open it and without connect to any DB’s I select menu voice - TOOLS - DATA GENERATOR - .At this point I select create a new project from database.

I attach a screenshot for details :

toad_add_db.jpeg

I insert a valid credential and I select refresh button, but nothing to do.

I can’t select a DB.

How can I use a tool like this ?

In past I open other request/bug about Data Generator, but today I have the same problem.

I stay tune for your consideration,

Best regards,

Sergio

Have you tried connecting to the database and selecting a table in Object Explorer, right click and data generator?

Hi Martin,

many thank's for your answer.

This is the results after follow your suggestions.

I attach a screenshot of the result :

As you can see I obtain an error.

Have you some others idea ?

Best regards,

Sergio

If you right click on the table and perform View Details, does that work? What are the details of the table, number of columns and data types? What version of SQL Server are you connected to and if SQL 2017 what OS?

Hi Martin,

yes I can right click on the table and view details without problems.

I attach a script of the table. As you can see itìs a simple table :

CREATE TABLE [dbo].[Price] (
[ProductID] int NOT NULL,
[LastUpdate] date NOT NULL,
[Price] smallmoney NULL,
[Qty] int NULL,
CONSTRAINT [PK__Price__B40CC6EDEF1FA2F8]
PRIMARY KEY CLUSTERED ([ProductID] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON,
DATA_COMPRESSION = NONE )
ON [PRIMARY]
)
ON [PRIMARY];
GO
ALTER TABLE [dbo].[Price] SET (LOCK_ESCALATION = TABLE);
GO

I use SQL Server 2012 with service pack 4 Developer edition at 64 bits and my operating system is windows 7 professional at 64 bits with service pack 1 plus last windows update in italian language.

Best regards,

Sergio

Hi Sergio,

yes there is a problem, we are looking into it. I will respond when I get a resolution for you.

Thanks,

Martin

Hi Martin,

I hope to see my problem solved.

Every time I try to use data generator tool I can’t use it.

I hope to see more usability and stability in data generator for the future.

Last year I’ve signaled another annoying bug and now is still present…

I stay tune for your consideration.

Best regards,

Sergio

Hi Sergio,

Yes, there was problems in Data Generator.

we have create defectID TSS-1494 for this, it should be fix soon.

Michael

Hi Michael,

it’s from 2 years that I can’t use Data Generator tool.

In the past, January 2016, I’ve open another case. This is the link : http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259

I test it with new version of beta version of TOAD SS 6.9 and the problem is still present.

Every time I want to use it I can’t.

It’s not normal…

Why do you release a tool if I can’t use it ?

Initially I can understand some problems. It’s normal with new feature…

But not after 2 years. It’s from 2 years that I wait to a fix for my problem with data generator…

I stay tune for your consideration.

Best regards,

Sergio

Hi Sergio,

Have you try our new beta build for v6.9 ?

you can download from : http://www.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/

Michael

Hi Michael,

I try to new beta of TOAD SS 6.9.

Now I can connect to data generator without problems, but the problem that I’ve singled 2 years and underline 2 years ago - http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259 - is still present !!!

For me is important to solve this…

I appreciate too much your interesting in my problem but for use Data Generator Quest’s developers must solve my problem.

I stay tune for your consideration,

Best regards,

Sergio

Hi Sergio,

We found TSS-1226 for this issue, and i have set High Priority for you.

it will be fix soon.

Thanks,

Michael

Hi Michael,

many thank’s for set the TSS-1226 to high priority.

Best regards,

Sergio