Drop all table and repopulate
in [Programming SQL]
|
From: Alex Kuznetsov on 2 Jul 2008 10:41 On Jul 2, 12:06 am, "Tibor Karaszi" <tibor_please.no.email_kara...(a)hotmail.nomail.com> wrote: > PMFJI (in case I've missed something earlier in this thread), but disabling a FK constraint for a > referenced table doesn't allow for TRUNCATE TABLE. Whenever I see requests like these ("scratch a > database" I keep wondering why not just drop the database and re-create it using the build scripts > (DDL files). And I also feel like not having build scripts is not an option - like having an exe > file you developed but you no longer have the source code... PMFJI, but I also feel like not having build scripts _in_source_control_ is not an option either...
From: Uri Dimant on 2 Jul 2008 11:03 Alex >PMFJI When I first looked at this words I though the last one is L in russian , isn't it ? :-)))) "Alex Kuznetsov" <alkuzo(a)gmail.com> wrote in message news:35134336-f9c0-451e-8760-0c123345ec4c(a)l28g2000prd.googlegroups.com... > On Jul 2, 12:06 am, "Tibor Karaszi" > <tibor_please.no.email_kara...(a)hotmail.nomail.com> wrote: >> PMFJI (in case I've missed something earlier in this thread), but >> disabling a FK constraint for a >> referenced table doesn't allow for TRUNCATE TABLE. Whenever I see >> requests like these ("scratch a >> database" I keep wondering why not just drop the database and re-create >> it using the build scripts >> (DDL files). And I also feel like not having build scripts is not an >> option - like having an exe >> file you developed but you no longer have the source code... > > PMFJI, but I also feel like not having build scripts > _in_source_control_ is not an option either...
From: Alex Kuznetsov on 2 Jul 2008 11:25 On Jul 2, 10:03 am, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Alex>PMFJI > > When I first looked at this words I though the last one is L in russian , > isn't it ? :-)))) > Uri, PMF/\ ? What would that stand for ;)
From: Tibor Karaszi on 2 Jul 2008 13:27
> PMFJI, but I also feel like not having build scripts > _in_source_control_ is not an option either... Agreed. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Alex Kuznetsov" <alkuzo(a)gmail.com> wrote in message news:35134336-f9c0-451e-8760-0c123345ec4c(a)l28g2000prd.googlegroups.com... > On Jul 2, 12:06 am, "Tibor Karaszi" > <tibor_please.no.email_kara...(a)hotmail.nomail.com> wrote: >> PMFJI (in case I've missed something earlier in this thread), but disabling a FK constraint for a >> referenced table doesn't allow for TRUNCATE TABLE. Whenever I see requests like these ("scratch a >> database" I keep wondering why not just drop the database and re-create it using the build >> scripts >> (DDL files). And I also feel like not having build scripts is not an option - like having an exe >> file you developed but you no longer have the source code... > > PMFJI, but I also feel like not having build scripts > _in_source_control_ is not an option either... |