Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ansz5
Starting Member
4 Posts |
 Posted - 2009-03-20 : 02:52:42
|
| What is a Staging table ?How to use it ?And When is it advised to use Staging tables - When transferring data between 2 diff servers or when there are 2 different dbs on the same server ?Thanks ! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-03-20 : 10:20:21
|
http://blogs.msdn.com/sqlrem/archive/2008/02/22/the-wizard-s-wand-to-partitioning-creating-staging-tables-adroitly-simple.aspxMaybe that is what you want to know...Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-20 : 10:49:41
|
quote:
Originally posted by ansz5
What is a Staging table ?How to use it ?And When is it advised to use Staging tables - When transferring data between 2 diff servers or when there are 2 different dbs on the same server ?Thanks !
one common scenario where staging table is used in case where data is transfered between two servers and you want to apply only delta changes from source to destination on each transfer.here the delta change is first transfered to staging and then applied to destination |
|
|
|
|
|
|
Staging Table