Thursday, March 19, 2009
Unexpected functionallity in VS 2005 and VS 2008 Database Projects - Data Generation Plans
By default when creating a new Data Generation Plan all tables and columns are selected. When you rename or add a new a column the Data Generation Plan prompts you with Schema Changes dialog window showing the table and column changes. The modified or new columns are now deselected which is a pain and you have iterate through all the tables selecting all the columns that have changed manually. If the column was previously selected VS should prompt you whether you want to keep that column selected and new columns should be automatically selected.