Visio 2005 Database Update.

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.
 
J

jv

I am having the same problems. In addition to the issues you listed, when I
try to update the database (generating the alters in DDL), it tries to delete
all of my constraints, referencing them with truncated names, and re-add
them with the original non-truncated names. Needless to say, the truncated
names are not found in the database and the constraints are not added because
they already exist with the original names in the database. Definitely a BUG!
I have added alternate keys to my tables, and those are not found when I run
the update database wizard, yet they are in the model and are not in the
physical SQL Server 2005 database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top