InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 00:39:12 GMT20http://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxPlease note: 2 year old thread.Sun, 03 Apr 2011 23:30:19 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxYou might try the SQL Server Publishing Wizard. Works with SQL Server 2000 & 2005. Integrated into Visual Studio 2010 for SQL Server 2008.Sun, 03 Apr 2011 17:35:17 GMTRobert Hineshttp://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxAnother suggestion or two: Think about the future, after the initial backup/restore, detach/attach; updating production can be tricky. Make plans on how changes will be performed to production. (approval process, logical steps, physical steps, etc.) "If you fail to plan, then you plan to fail." Trust me on this, spend some time thinking and documenting this. In addition, get a third party tool that can compare two databases (security settings, users, structure, etc. etc.); and can generate scripts that will get the databases in sync. Since many production database are directly related to the bottom line ($$$), it should be easy to justify the expense. $0.02Thu, 31 Mar 2011 05:48:09 GMTDoug Stevenshttp://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxand in case you have trouble with orphaned users, this link may come in handyhttp://support.microsoft.com/kb/918992Wed, 11 Mar 2009 08:03:45 GMTrholland82http://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxHope the staging and production servers both are SQL Server 2005.Use backup and restore if you want to keep database in staging server.Wed, 11 Mar 2009 06:05:22 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxYep, that's true sorry did not mention it. Wed, 11 Mar 2009 05:28:08 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic673010-146-1.aspx[quote][b]Krishna (3/11/2009)[/b][hr][quote][b]karan457 (3/11/2009)[/b][hr]Hi i need to deploy my final database from staging server to production How to deploy database in production server[/quote]The fastest operation is to detach it and attach on your production server.[/quote]If you are going to use this method or backup/restore then make sure you have cleaned out any test data that may be in the database first..Wed, 11 Mar 2009 05:20:27 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic673010-146-1.aspx[quote][b]karan457 (3/11/2009)[/b][hr]Hi i need to deploy my final database from staging server to production How to deploy database in production server[/quote]The fastest operation is to detach it and attach on your production server.Wed, 11 Mar 2009 05:16:26 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxFew ways ....1) If you have all the scripts for all objects.. then create new db run the scripts.2) Backup database and restore on to production3) Deattach-reattach to production.If this is new application most likely #2 will work just fine for you :). You'll have to do security bit after that .. that would go for each case :).Mohit.Wed, 11 Mar 2009 00:59:52 GMTMohit K. Guptahttp://www.sqlservercentral.com/Forums/Topic673010-146-1.aspxHi i need to deploy my final database from staging server to production How to deploy database in production serverWed, 11 Mar 2009 00:17:40 GMTkaran457-979314