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 |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2007-08-13 : 15:43:15
|
| I have approximately 400 - 600 tables that need to have their filegroups changed on a new SQL 2005 installation. In 2000, I could go the table properties in Enterprise Manager and change the filegroup, but on 2005 Management Studio, I can view (but not change) the table properties.I realize that I can create the table on the other filegroup using a new name, move my constraints and indexes to this new table, copy the data over, drop the original table, then rename the new table to the name my application is expecting. But that could take me weeks (especially with such a time-consuming process)! I don't mind the process being so slow, but I do mind it being labor intensive. Does anyone have an idea how I can automate this process (or at least make it as easy as it was with Enterprise Manager?)Paul Teal |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 15:51:16
|
| Or just create clustered index on new filegroup. |
 |
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2007-08-13 : 15:54:47
|
| Then drop the clustered index? That would be faster.Paul Teal |
|
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2007-08-13 : 16:05:25
|
| This is working great, I will have to modify the proceedure slightly for the tables that already have a clustered index, but that is no problem. Thanks for the help, rmiao.Paul Teal |
|
|
|
|
|
|
Change Table Filegroups on 2005