Testing database
in [Programming SQL]
|
Prev: UDF Error
Next: BUY FAKE PASSPORTS OF AUSTRALIA,FAKE AUSTRALIAN PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORT
From: Michael C on 15 Mar 2010 00:05 Assuming a company that releases software to the public, what methods do you use to manage testing/development database. This can sound pretty simple but when you have a team of developers it can get pretty complicated. Do you have a single database that everyone develops in or seperate databases on each machine? If you have separate databases, how do you sync changes from each developer to each other? How do you release their changes? Cheers, Michael
From: Uri Dimant on 15 Mar 2010 03:33 Michael C We have development test with one (for this project) database. Every developers do changes and check for bugs and etc. then if it is approved I used SQL Compare tool of Red Gate to syncronyze prod. and dev databases.. "Michael C" <mike(a)nospam.com> wrote in message news:erPd9S$wKHA.732(a)TK2MSFTNGP06.phx.gbl... > Assuming a company that releases software to the public, what methods do > you use to manage testing/development database. This can sound pretty > simple but when you have a team of developers it can get pretty > complicated. Do you have a single database that everyone develops in or > seperate databases on each machine? If you have separate databases, how do > you sync changes from each developer to each other? How do you release > their changes? > > Cheers, > Michael >
From: Michael C on 15 Mar 2010 21:22 "Uri Dimant" <urid(a)iscar.co.il> wrote in message news:u4311GBxKHA.1692(a)TK2MSFTNGP04.phx.gbl... > Michael C > We have development test with one (for this project) database. Every > developers do changes and check for bugs and etc. then if it is approved I > used SQL Compare tool of Red Gate to syncronyze prod. and dev databases. So you one central dev database? Do you find this causes problems? We do that with this project but it can cause problems if someone is importing large amounts of data in that everyone else can grind to a halt. Also, when you send your app out to the customer how do you update all the stored procs etc? Cheers, Michael PS, it's interesting that I only got 1 reply, it looks like most here are working on internal projects I guess.
From: Uri Dimant on 16 Mar 2010 02:58
Michael C No we did not have problems so far. Actually we are not importing the data into a dev server as everybody uses a full backup of prod. database , what is the purpose? > Also, when you send your app out to the customer how do you update all the > stored procs etc? Third party tool of www.red-gate.com "Michael C" <mike(a)nospam.com> wrote in message news:eTHTxcKxKHA.3304(a)TK2MSFTNGP06.phx.gbl... > "Uri Dimant" <urid(a)iscar.co.il> wrote in message > news:u4311GBxKHA.1692(a)TK2MSFTNGP04.phx.gbl... >> Michael C >> We have development test with one (for this project) database. Every >> developers do changes and check for bugs and etc. then if it is approved >> I used SQL Compare tool of Red Gate to syncronyze prod. and dev >> databases. > > So you one central dev database? Do you find this causes problems? We do > that with this project but it can cause problems if someone is importing > large amounts of data in that everyone else can grind to a halt. > > Also, when you send your app out to the customer how do you update all the > stored procs etc? > > Cheers, > Michael > > PS, it's interesting that I only got 1 reply, it looks like most here are > working on internal projects I guess. > |