Development DB to Production DB

We have a development SQL server and a production SQL server. Is there
anyway to replicate what we create on the Dev box over to production box
when we are finished our testing?
Thanks.
TomHi,
DId you meant to replicate database in development to Production, if that
is the case you can go for any of the below options,
1. Detach the database in development and attach it in production
2. Backup the development database and Restore in production
Thanks
Hari
MCDBA
"Tom Pennington" <NONEt2pennington@.comcast.net> wrote in message
news:OKUPhQdDEHA.2768@.tk2msftngp13.phx.gbl...
> We have a development SQL server and a production SQL server. Is there
> anyway to replicate what we create on the Dev box over to production box
> when we are finished our testing?
> Thanks.
> Tom
>|||Backup and restore, detach/attach/Alter scripts, update/insert queries...
Depending on exactly what you want to Move (anywhere from entire database
with data to one stored procedure) there a number of ways to accomplish
this.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Tom Pennington" <NONEt2pennington@.comcast.net> wrote in message
news:OKUPhQdDEHA.2768@.tk2msftngp13.phx.gbl...
> We have a development SQL server and a production SQL server. Is there
> anyway to replicate what we create on the Dev box over to production box
> when we are finished our testing?
> Thanks.
> Tom
>|||We use ErWin To make changes to Dev.
Then we Point ErWin to QA, Etc and have it generate "Diff Scripts" for us.
The scripts are included with our Roll to Production plan.
Just another way to do the same thing
ErWin is Not "CHEAP" but I think it is a very powerful, valuable tool.
It's primary competitor is ER-Studio which I think is a little better.
Cheers
Greg Jackson
PDX, Oregon