Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2002-09-29 : 22:16:47
|
Hi legends. OK, now I don't think I've ever even read a post in the Admin forum, let alone posted one ...(not my area)!Trying to use the upgrade wizard from 6.5 to 7.0. All databases work fine except one, which gets loads of errors apparently because it has all the dt_% procedures (like dt_adduserobject) but not the dbo.dtproperties table which does not exist.I'm a bit confused because I thought that all the dt_% type procedures were a 7.0 thing and not in a 6.5 database? But this one has the procedures in any case. The admin guy asked me to help, coz he's stuck...and he doesn't know the history. I suspect that I'll be able to complete the upgrade OK, if I first remove all the dt_ stored proceduresm from the 6.5 database in question...anyone know any more on this?--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-10-01 : 07:37:59
|
| As far as i know the dtproperties table (and possibly the dt_% SPs) only exists if you have a database diagram setup as opposed to using triggers for referential integrity and cascading. With this in mind you will know if you can safely remove the dt_% procedures. i.e. do you use a database diagram for RefI or triggers ??Why not script up the stored procedures > upgrade > if needed you can run the script in SQL7 to recreate the SPs.Hope that helps in some capacity anyway ?===========Paul |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-10-01 : 18:06:09
|
| Thanks PaulI'll give it a go then - hell what are backups for!Cheers--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Upgrade from 6.5 - dtproperties