Data Generation Plan

Hi,

I wonder if someone can help!

I am using 'database professional' within visual studio and am in the process of creating and populating a target database (my own local database) in order to implement some sort of source control.

I have managed to deploy the master database on to my local machine but I am having problems when performing a 'data generation plan' in order to migrate the data in to the database schema tables.

The error I keep getting is,

Error 3 Table employee : System.Data.SqlClient.SqlError: The level for job_id:0 should be between 93 and 85. C:\testprodb\Database11\Database11\Data Generation Plans\DataGenerationPlan1.dgen 2 0 Database11

Does this imply constraint issues or is it my default level setting which is at fault?

Please note that job_id within the employee table is a foreign key field!!

Any help would be much apprieciated.

Slim5y..

[954 byte] By [slim5y] at [2008-1-7]
# 1
Did you set the Min and Max properties of the generator for the column to match the column constraint in the database? That may be the issue you're seeing. I'll try working through this when I get back to my test machine.
JeffWeltonMSFT at 2007-10-2 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

Slim5y -

Are you still blocked by this issue, or did Jeff's post help get you unblocked?

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

Slim5y -

We are still waiting on information from you. If we don’t hear from you in the next seven days, we will delete the thread. We do this to keep the system full of useful information for customers searching for answers and focus expert attention on active unanswered questions.

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

Visual Studio Team System

Site Classified