Best way to manage SQL Server on developer, test, staging, and production environments through Visual Studio 2013 -

-

i've read article on ms blog , on here on stackoverflow , this article

they shed light on scenario, feel may missing something...

the third article above nicely explains possible way deploy database versions including schema , data... oriented deploying production.

i looking streamline deploying dbproj's developer db instances , test, staging , production.(all sql2012 std. edition)

on developer instances, may few versions off... have contractors leave , may couple of dev cycles before new contractor tries deploy.

also, how schema on target clean itself? know can turn off restrictions remove schema objects, on developer workstation instances logins different other environments , not want deleted!!! second article has clues not work when tried it. have 1 application role across environments , depending on environment right login placed in there.

i have sense may have propose changing our schema, may not fly the other leads.

i appreciate hearing has tried , true process in place can cover seamless deployment 4 environments described above.

thanks!

you might interested in deployment manager , sql source control red gate (full disclosure - work red gate).

the approach these 2 products use keeping development environments in sync is:

  • developers edit local database make changes (or edit shared db across whole team)
  • developers can synchronized database existing source control repository (e.g. svn/git/tfs) using sql source control
  • other team members can update databases repository, , changes applied local database.

deployment manager works ci server allow automated deployment of version of database set of predefined environments. example might want automated deployment integration environment after every commit. deployments out test/staging/production environments push button deployments when required.

under hood it's red gate sql compare comparison technology compare versioned database state target database state. means development database can updated latest state, if older head revision, or new member joining team.

you can include filters within packages/repository exclude objects (for examples users, roles, keys, specific schemas). means can deploy same version/package each environment, , won't interfere these objects.

my colleague has written great intro blog post videos if you're interested in more info.


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses
Read more

SQL: Divide the sum of values in one table with the count of rows in another -

-
is possible to, in single query, sum bunch of values in 1 table, , divide count of rows in another? there common id/key in both tables... fyi, win points least info provided in question. answer it's possible...here psuedo code since i'm guessing @ tables , columns select summing / counting whynot (select id, sum(whatever) summing where_ever ) inner join (select id, count(1) counting what_ever)b on a.id = b.id question = 'vague' group a.id
Read more