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

Deploy SQLS Database to a Produtiv-System Expand / Collapse
Author
Message
Posted Thursday, September 27, 2012 12:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 7, 2014 8:05 AM
Points: 53, Visits: 179
Hi,
is there a guide or checklist for deploy SQL Server databases (2008/R2) after development and testing to a productiv/live platform? What are the requirements and permissions it needs, so the topic Deployment, Support, Database update not turn into a nightmare.
=> What should I consider (Compare, Synchronice, Server Roles, Database Roles) so that a DBAdmin can live with that ..... :)
I have to deploy (Database with Tables, Views, StoredProc., Functions)

Thank you

Kind regards
Nicole

Post #1365050
Posted Thursday, September 27, 2012 2:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 5,227, Visits: 5,087
Permissions roles etc will all depend on how you want to lock down access to the databases, only you know what the applications are doing to the database so only you can really decide what rights to give to users.

The main thing I would say if setup a backup routine for the newly created database(s) as that will be critical.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1365084
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse