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 |
|
Blastrix
Posting Yak Master
208 Posts |
 Posted - 2004-04-12 : 13:33:04
|
| How do some of you out there handle multiple versions of applications against the DB? Say I have my main development line of v1.0, and am starting work on v1.1. If a bug is found in 1.0, I need to update that, and get it released, but what if some structural changes have happened to the DB with 1.1 that are not ready to be released with 1.0.1? Do you recommend maintaining a DB for each development line?Thanks,Steve |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-12 : 13:37:03
|
| What we do is create another SQL instance on that development server if they require different versions of the schema. You can also have one version point to the same instance but a copy of the database using a different name (DBName_vNumber). And yes I recommend having a distinct database for each version.Tara |
 |
|
|
|
|
|
Handling multiple application versions.