Friday, February 17, 2012

Dev to Prod

I am building a new database in a Development environment (tables, stored pr
ocedures...etc.). Can you suggest reliable ways to move it to Production wh
en the project is ready to move to prod. This is kind a new to me and I am
wondering what tools would
be helpful.
ThanksIt depends on what you want to move. I have elaborated on different tools to
generate scripts, some with data on below line:
http://www.karaszi.com/sqlserver/in...rate_script.asp
Also, backup/restore or detach/attach is an option, but you need to handle
orphaned users after.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Niles" <anonymous@.discussions.microsoft.com> wrote in message
news:C073E2DC-DAD3-4516-B304-112EB810EF31@.microsoft.com...
> I am building a new database in a Development environment (tables, stored
procedures...etc.). Can you suggest reliable ways to move it to Production
when the project is ready to move to prod. This is kind a new to me and I
am wondering what tools would be helpful.
> Thanks

No comments:

Post a Comment