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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-06 : 09:52:12
|
| Benz writes "Hi All,I've a database model in MS Visio and I generate the DDL script for this model from Visio itself and execute the script to create a database. If after sometime there are any changes made to the model in Visio, I regenerate the DDL script. Now I need to update the database with these changes, Is there a stored procedure or function that does a "difference" or compare of the two table schemas that will identify the differences??. If I've got to use SQL DMO, then pls let me know how do I do it???" |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-06 : 09:59:10
|
| There isn't any procedure or function which would do that, you can however, write one yourself (if you have the time and nerves) or you can checkout third party tools for comparing DB's. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-06 : 10:11:20
|
| Oh...akhmm...Like I said, or Graz's article. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-01-06 : 11:15:03
|
| might be cheaper (and easier) to go to ww.red-gate.comthey have a product to do just this....available on 30 day trial over the web. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-06 : 12:41:11
|
| I concur with AndrewMurphy. We have found that tool, SQL Compare, to be of great value. It is pretty cheap too. I use it probably once or twice a week, and it saves me so much time. |
|
|
|
|
|
|
How to update database??