D
dbirch
I am having a problem with Visio 2005 trying to both drop and update the same
table in a SQL server database. This is to the best of my recollection how I
got to this point:
1. Went on vacation
2. Some other developer added a new table to the database.
3. First day back, did a database update.
4. The wizard found the new table and I selected to update the model. There
was no database updates to perform.
5. Performed a second database update without the update database checked
(I find that sometimes Visio misses some things on the first try)
6. The wizard found a difference between the model and the database so I
let it update the model.
7. I tried to perform a third database update (without update database
checked) and got an error with two indexes (constraint only) with the same
name.
8. I deleted one of the indexes from the new table and then tried to do a
third database update.
9. The wizard reported a difference again so I indicated to update the
model. The wizard looked like it wanted to add the index again so I cancel
the update.
10. I decided to delete the table from the model and reengineer the
database. This returned the table back into my model.
11. When I tried to run the database update again, the wizard found no
differences. However it wanted to delete the new table from the database. I
don’t know why so I canceled the update.
12. Just for fun I added a new column to the new table.
13. When I tried to run the database update again, the wizard found no
differences. This time it wanted to change the database by dropping the
table and update the same table with the new column.
It appears to me that somehow Visio has two tables in my model with the same
name. One is deleted from the model but not yet from the database. The
other is in the model with a new column that needs to update the database.
Anyone know what I should do short of re-engineering the whole model from
scratch. I have spent a lot of time making the diagrams look good and typing
in logical information in the column notes. I don’t want to start over.
table in a SQL server database. This is to the best of my recollection how I
got to this point:
1. Went on vacation
2. Some other developer added a new table to the database.
3. First day back, did a database update.
4. The wizard found the new table and I selected to update the model. There
was no database updates to perform.
5. Performed a second database update without the update database checked
(I find that sometimes Visio misses some things on the first try)
6. The wizard found a difference between the model and the database so I
let it update the model.
7. I tried to perform a third database update (without update database
checked) and got an error with two indexes (constraint only) with the same
name.
8. I deleted one of the indexes from the new table and then tried to do a
third database update.
9. The wizard reported a difference again so I indicated to update the
model. The wizard looked like it wanted to add the index again so I cancel
the update.
10. I decided to delete the table from the model and reengineer the
database. This returned the table back into my model.
11. When I tried to run the database update again, the wizard found no
differences. However it wanted to delete the new table from the database. I
don’t know why so I canceled the update.
12. Just for fun I added a new column to the new table.
13. When I tried to run the database update again, the wizard found no
differences. This time it wanted to change the database by dropping the
table and update the same table with the new column.
It appears to me that somehow Visio has two tables in my model with the same
name. One is deleted from the model but not yet from the database. The
other is in the model with a new column that needs to update the database.
Anyone know what I should do short of re-engineering the whole model from
scratch. I have spent a lot of time making the diagrams look good and typing
in logical information in the column notes. I don’t want to start over.