Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to deploy database in production server Expand / Collapse
Author
Message
Posted Wednesday, March 11, 2009 12:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 11, 2009 4:04 AM
Points: 43, Visits: 269
Hi i need to deploy my final database from staging server to production



How to deploy database in production server
Post #673010
Posted Wednesday, March 11, 2009 12:59 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, August 23, 2014 10:43 AM
Points: 942, Visits: 1,064
Few 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 production

3) 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.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #673021
Posted Wednesday, March 11, 2009 5:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
karan457 (3/11/2009)
Hi i need to deploy my final database from staging server to production



How to deploy database in production server


The fastest operation is to detach it and attach on your production server.

Post #673098
Posted Wednesday, March 11, 2009 5:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
Krishna (3/11/2009)
karan457 (3/11/2009)
Hi i need to deploy my final database from staging server to production



How to deploy database in production server


The fastest operation is to detach it and attach on your production server.



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..
Post #673101
Posted Wednesday, March 11, 2009 5:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
Yep, that's true sorry did not mention it.

Post #673104
Posted Wednesday, March 11, 2009 6:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,633, Visits: 3,977
Hope the staging and production servers both are SQL Server 2005.

Use backup and restore if you want to keep database in staging server.
Post #673143
Posted Wednesday, March 11, 2009 8:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:19 AM
Points: 24, Visits: 218
and in case you have trouble with orphaned users, this link may come in handy

http://support.microsoft.com/kb/918992
Post #673269
Posted Thursday, March 31, 2011 5:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:47 AM
Points: 72, Visits: 115
Another 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.02




Post #1086772
Posted Sunday, April 3, 2011 5:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 5:27 AM
Points: 1, Visits: 6
You might try the SQL Server Publishing Wizard. Works with SQL Server 2000 & 2005. Integrated into Visual Studio 2010 for SQL Server 2008.
Post #1087883
Posted Sunday, April 3, 2011 11:30 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 40,209, Visits: 36,618
Please note: 2 year old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1087906
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse