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 |
|
kelleyb
Yak Posting Veteran
61 Posts |
 Posted - 2001-11-16 : 08:23:06
|
| I'm looking for a little guidance here. I've been developing a rather complicated e-commerce web application. So far, I've had the luxury of a development server and a production server that was not yet "released" to the masses. In order to mirror as much of the production environment as possible, the development server is nearly identical to the production server with the exception that a few more applications are installed.But now, the website is partially functional and accepting "live" data. There is still more to be developed, so I must find a solution where I can "upload" my changes without destroying the data on the production server.My migration solution has been several command-line based DTS packages which upload all new structures and changed data within. Now, I know about "ALTER TABLE", though I've never used it (never had a need to).My request is:Can you please provide some direction on how I might **AUTOMATE** the process of replicating SQL structure changes from my development server to the production server without destroying the live data on the server. I'm happy to look in BOL, but to date I haven't run across anything that would indicate I can automate this procedure."Grove giveth and Gates taketh away." - Bob Metcalfe (inventor of Ethernet) on the trend of hardware speedups not being able to keep up with software demands. |
|
|
|
|
|
Updating SQL structures without loosing data