Wednesday, January 25, 2012 9:32 AMHi,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.
Thursday, January 26, 2012 11:56 PM
Tuesday, January 31, 2012 2:16 AMModerator
Do you still need assistance about this thread? Catherine raised a question.
Forrest Guo | MSDN Community Support | Feedback to us
Sunday, April 08, 2012 3:24 PM
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.
Thursday, April 19, 2012 9:17 AM
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.
Thursday, August 23, 2012 4:17 AM
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."