database updating from development version

[onressy]

I have have sql2005 on both a development server and webserver. I've decided to do development offline, which is a big change for me. What i did was copy the mdf and ldf file to the development and attach the db, i'm a web programmer. Now i have made some change to various table and stored procedures. So i would like to modify the webserver db structure, not data, since new records have been created during development. I can change the stored procedures my self as there are but a handful. Bur my issue lies in transfering the structure over not with the data?

I'm wonding if it would easier populating the development db with update webserver records?, then just transfer the mdf and ldf files from dev to web?

Thanks for you suggestions!

 

[mrdenny]

When releasing changes from Dev to Production you need to write a release script which will make all the table structer changes for you as well as release all the updated stored procedures.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

You might want to make sure Sarbanes-Oxley doesn't affect you and your workplace, btw. SOX changes the way all software development is implemented for certain size/types of companies.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"