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 |
|
calvin464
Starting Member
11 Posts |
 Posted - 2005-11-10 : 21:34:16
|
| Hi,I'm new to SQL Server. How do I port the modifications of my table structures, store procedures, functions on the staging server to the procduction server without affect the data?Can I make this modification to production database while user are still accessing the database or I have to bring down the database to make these changes?Thanks in advance, |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-10 : 22:01:18
|
| We script every change to the DDL (and call the file "PATCH01.SQL" ...), and store each SProc / Trigger in a separate file.We then "execute" all files since the last update-date of the QA / Staging / Production server.In Enterprise Manager : Design Table there is a button to "Generate Change Script" that will give you a script instead of actually making the change (and there's a checkbox on it to cause it to display if you accidentally press SAVE instead - so you can have a script after-the-fact)As you won't have such a tool you need something that will generate a change script by comparing your DEV database with your Staging one (or a local copy of it, if needs be). Red-Gate have such a tool I believe.If you want to get all your current SProcs into individual files there is a "create one file per object" option in Enterprise Manager : Generate SQLKristen |
 |
|
|
|
|
|
how to move database