Developer turned DBA newbie Q

I have taken a new gig and I'm the one thrown into the DBA gig.
I have a Dev system that needs to get "real" data from stage server. One
table has triggers that insert into 4 other tables. I need to bring in
data
that is giving me errors because of unique data in those other tables.
TableA triggers inserts into TableB,C,D&?
When I get the insert into TableA, TableB kicks the error back about
unique
index failure.
So what is the best way to get the data into TableA? Inquiring minds want
to know? I can restore a backup, but it's 10 gig and then I have to deal
with the users into the db that need access.
Or should I disable the triggers?
TIA
__StephenIMHO, the way to go here is a backup/restore, after you verify that all the
developers have saved their changes to the db so their work won't be
lost...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Stephen Russell" <srussell@.lotmate.com> wrote in message
news:u$LvEx$iFHA.1416@.TK2MSFTNGP09.phx.gbl...
>I have taken a new gig and I'm the one thrown into the DBA gig.
> I have a Dev system that needs to get "real" data from stage server. One
> table has triggers that insert into 4 other tables. I need to bring in
> data
> that is giving me errors because of unique data in those other tables.
> TableA triggers inserts into TableB,C,D&?
> When I get the insert into TableA, TableB kicks the error back about
> unique
> index failure.
> So what is the best way to get the data into TableA? Inquiring minds want
> to know? I can restore a backup, but it's 10 gig and then I have to deal
> with the users into the db that need access.
> Or should I disable the triggers?
> TIA
> __Stephen
>
>