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 |
|
WoodHouse
Posting Yak Master
211 Posts |
 Posted - 2010-04-28 : 14:12:58
|
| WE have two partitioned tables named Transaction and TransactionHistory. we need to archieve one of the partitions of the Transaction table to the TransactionHistory table. which method should we use1.ALTER TABLE SWITCH2.INSERT ...SELECT ...TRUNCATE TABLE3.ALTER PARTITION FUNCTION...MERGE...4.ALTER PARTITIION FUNCTION..SPLIT.....Please help on thisThankswood |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-04-29 : 09:32:46
|
| If the tables share the same partition scheme and function then it should just be a simple switch statement to go from transaction to trans history using : alter table Transaction move partition X to TransactionHistory partition xMike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Partitions