sql server - can dacpac be used for managing databases having large volume of data? -


our current database of 200mb, once application goes live, expecting grow large volume.. may be, 20-30 gb of data in that.

we planning use "dacpac" (generated database project - ssdt) deploy on production server. database created number of tables, , lots of initial data in lookup tables.

however, concern future deployments when using "dacpac" (generated database project - ssdt) upgrade database on production server.

as have no past experience of using dacpac deployments, can please suggest me following -

  1. does deployment depend on volume of data? or if depends upon schema changes? example, if target database of 20-30 gb, how approximate time can take upgrade it?
  2. how can version database schema?
  3. can upgrade process rolled if goes wrong?

and lastly, better traditional way of manual writing sql scripts upgrade database?

  1. from experience, volume of data have impact when deploying dacpac. time increase depend on changes being applied in dacpac across database. advice here try , test larger volumes of data gauge increase in time, may minimal

  2. all our objects stored within sql server data tools (ssdt) visual studio project, version controlled within tfs, when need build based on additional checking, create new version us

  3. this can depend on type of updates applying, , whether wish invest time in understanding take rollback each schema update.

i using dacpac's , find useful hosting sql objects within 1 visual studio project. going manual way increase chances forget include 1 or more patches due number of changes required.


Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

i added new project. made mistake in projectname.conf file in sites-available apache2, led me reinstalling apache2. after reinstalling , re-enabling projects on every page of every project .. <body> run(); </body> .. i've run composer update, restarted service, restarted pc, checked config files, tried disabling new project. there nothing in error log, , access.log: 127.0.0.1 - - [15/may/2015:01:40:47 +0200] "get / http/1.1" 304 181 "-" "mozilla/5.0 (x11; ubuntu; linux x86_64; rv:38.0) gecko/20100101 firefox/38.0" maybe i'm forgetting apache2 reinstall? don't think did different last time installed it. looks haven't setup php correctly. take @ this great guide , maybe you're forgetting link php config apache2.
Read more

php - How can I echo out this array? -

i don't know how go grabbing data in variable , put foreach loop. class tree{ private $info = array( array('name'=>'jim','state'=>'nu','company'=>'nu','phone'=>array('cell'=>'5615111111','office'=>'5611111111'),'email'=>array('primary'=>'exs@example.com','ex@there.com')), array('name'=>'joe smith','city'=>'phoenix','phone'=>'4805551111','email'=>'jsmith@some_email.com'), array('name'=>'john doe','city'=>'chandler','company'=>'doe co.','email'=>array('jdoe@gmail.com','personal'=>'email@email.com'),'phone'=>'6025550002') ); } if you're inside of class, can access private variable using $this->variablename . example, i...
Read more