December 13, 2011 at 8:59 am
hI Friends,
Can someone explain what is Schema Refresh in SQL SERVER ?
December 13, 2011 at 9:05 am
IIRC it’s not a standard term. Schema Refresh usually refers to truncating & re-populating the whole database / schema.
The following PPT explains it (with Oracle commands).
December 13, 2011 at 9:16 am
As mentioned, it's not "standard terminology". I've usually heard it in reference to synchronizing schemas between servers, usually either Dev -> Test or Test -> QA or QA -> Production, or something like that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 13, 2011 at 11:13 am
I have heard it refered to more as "dev server refresh" or "staging server refresh" where the dev or staging environments are blown away an replaced by scrubbed production versions. This may or may not include new hardware..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply