Data Generator is throwing error

Question

Hi,

I have created the simple data generation plan for 3 tables. After setting all the properties, when I ran the Data generation it is throwing the message as "An error occurred loading the plan". Can you please help to solve this?

And also for data population for one of the table, for some of the rows I want to assign value X, for some of the values Y and for some of the values Z. Please help to achieve this.

---

Porus

Answer 1

Hi Porus,

>when I ran the Data generation it is throwing the message as "An error occurred loading the plan"

Is there any other more detailed error info shown? Which version of VS are you using?

---

Catherine Sea
Version Control Software | TFS Hosting Service

Answer 2

Porus,

Do you still need assistance about this thread? Catherine raised a question.

 

---

Forrest Guo | MSDN Community Support | Feedback to us

Answer 3

Hi Catherine,

I need assistance.

I have got the same error. There is not any other more detailed error.

I use VS 2010 Ultimate.

I try generate test data on SQL Server 2012 RC0.

Answer 4

I have the same error. My steps are:

1. Deploy the database from database project in VS2010

2. Create a Data Generator plan, select a single, simple table, with all default settings set.

3. Preview the data (no problems)

4. Start "Generate data" on the data menu, connect to the DB in step 1, choose to delete data, and I get the An error occurred loading the plan

The additional error messages (in the Error windows) is:

The database schema provider could not be determined from the provided connection string.
You cannot generate data because no translation is available between the model that is used in the data generation plan and the model for the target database.

The problem was that I was running against a SQL 2012 server (with a SQL2008 database). By moving to a SQL 2008 server, it worked.

Answer 5

Hi SteinM,

I am using SQL Server 2008 still getting the same error "You cannot generate data because no translation is available between the model that is used in the data generation plan and the model for the target database."