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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy