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 |
|
Hippi
Yak Posting Veteran
63 Posts |
 Posted - 2011-02-01 : 20:41:34
|
| Hi folks,I have a big database with > 50 partitions and corresponding 50 filegroups. I want to somehow make a duplicate to another database which only uses primary partition and file group. There are a couple of options I am considering currently1. Backup/Restore - don't think it works and it will require the same number of partitions in the destibation db2. Export/Import - never try this3. Copy databases - never try this4. Copy table by tableI am wondering if anyone has done this before and could you share your experience/advice/insight?Thanks,Hippi. |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-01 : 22:37:28
|
Option 5-- maybe..Script the partition functions and change them all to put all partitions in the same filegroup. Script all the other objects as is. The new partition function is still being called, just all to one filegroup.Execute both scripts on the new server and use SSIS to copy all the data (or use the wizard to generate an SSIS package)Haven't done it before, but it might work.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
How to remove partitions when copying databases