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 |
|
sonnysingh
Starting Member
42 Posts |
 Posted - 2005-05-03 : 17:16:25
|
| Hi GuysI am working on upgrade one database from another.. first, I need to compare the structure of them and if structure is similiar then upgrade one database from another...Now situation is that I need to raise upgrade checklist before upgrade taken place..I have done my research on internet to get help in this but unfortunately, there are quite a lot literature i have found on upgrade sql server version to another version.. or migration.. rather on upgrade a database from another database under same SQL SERVER GROUP..could please any one help or advice me on create checklist on upgrade database..Thanx in Advance... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-03 : 17:46:37
|
| I use SQL Compare by Red Gate to compare databases if I'm unsure of what the differences are. I mentioned unsure as I'm typically sure of what the differences are due to source control.http://www.red-gate.com/SQL_Compare.htmTara |
 |
|
|
sonnysingh
Starting Member
42 Posts |
Posted - 2005-05-03 : 18:16:45
|
| Hi tduggan and FolksThanx for quick reply... I am using red gate for compare the structure..But I am using scripts and I need help in checklist before upgrade take place..I mean what approach should i take to write script to compare and upgrade required databse..and store result in a table.please help.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-03 : 18:20:05
|
| I don't understand. What would you like to store in the table?If you already know what needs to be upgraded since SQL Compare told you what to do, then what else is it that you need? SQL Compare provides the code as well as doing a comparison. I don't typically use their code though as they go the long way when all you might need to do is expand a column from varchar(50) to varchar(200).Tara |
|
|
|
sonnysingh
Starting Member
42 Posts |
Posted - 2005-05-04 : 02:20:01
|
| HiI just want advice on what precautions and gradaually steps i should follow.. since i am deveoloping manual upgrade scripts..I want ot store in table the results such as object type, object name, missing or addtional in upgraded database and different then store the differences..etc...well i more focus on finalising checklist then i will proceed further..Thanx a lot |
|
|
|
|
|
|
Upgrade a database from another database