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 - 2005-11-02 : 08:11:34
|
| Dennis writes "Situation:Currently we created the first version (1.0) of our application which uses MSSQL 2000 SP4. The database contains about 80 tables, 60 functions, 20 SP's, 10 defaults, full-text-search.Now we start to work on version 2.0. This will include changes to tables, sp's, etc.Questions:A: When we are finished with version 2.0 with it's database modifications, how can we upgrade a 1.0 database version to 2.0 without losing the 1.0 data?B: Is it possible to generate a difference-script/upgrade-script?C: Or will SQL 2005 have better options to do this?Because doing this. Step:1. Backup 1.0 database2. Install 2.0 database3. Restore 1.0 data on 2.0 version database Will cause matching problems.Thank you for your effort,Dennis" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-11-02 : 08:28:26
|
| "B: Is it possible to generate a difference-script/upgrade-script?"....yes....look at redgate.com for software to do this...available on trail/evaluation basis and reasonably priced too. |
 |
|
|
|
|
|
Upgrade database to newer version