March 29, 2004 at 8:58 am
I've recently been tasked with changing two of our existing UDTs. One is a character and one a decimal. They are literally used in 100's of places within our database - both in tables as well as within stored procedures.
The stored procedures should not be a problem as I can just rescript/recompile all of them.
The tables are another story... Are there are tools/scripts out there that can easily help achieve what I need to do? I'd rather not reinvent the wheel as I'm sure this has been done on numerous occasions.
thanks,.
Craig
March 29, 2004 at 3:05 pm
Most rdbms tools allow you to reverse engineer and change udts/domains and produce a change script. Erwin for one, Powerdesigner is another. I assume you need to maintain the data. You could script the database change the udts, then create a new db and copy the data across usin Import export wizard.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply