July 26, 2002 at 1:20 pm
I have a question.
Could anybody tell me, if in SQL Server 7.0 I can import through the DTS Import Wizard a table from one database into the User-Defined filegroup of another database?
If I can, what syntax I should use for the destination table?
Any help will be greatly appreciated.
Alex
July 26, 2002 at 5:28 pm
I dont think you get the option to pick a file group. You could just create the structure of the table manually and put it where you need it, then transfer the data to it. The other way would be to import it, then move the clustered index to the filegroup..which of course moves the table.
Andy
August 1, 2002 at 8:04 am
Thank you guys for your response,
Yes, I can move a table structure to a different filegroup with no problems.
But I cannot change a filegroup for the data in the table.
Let's say I'm changing 'Table File Group', 'Text File Group' and 'Index File Group' in 'Table & Index Properties' of the design mode of the table. After saving these changes a 'Text File Group' converts to the one which used to be before.
Or let's say, I'm transferring data to the table created with the 'Create Table...' statement ON a desired File Group. My data still remains in the 'Primary' File Group.
Is it a bug in SQL Server 7.0?
I'm trying to improve a database performance locating a huge tables on the different File Groups but cannot change a File Group of the actual data.
Can anybody help with that?
August 1, 2002 at 2:00 pm
Thank you Gary,
This worked on a Test database, but I would definitely prefer a different solution.
It is kind of scary to change a Default File Group in your production Database back and forth.
Maybe any other ideas?
August 1, 2002 at 2:03 pm
Moving the clustered index should do this. I'd be sure you save the changes, shut down EM and then go back to be sure it refreshes.
Steve Jones
August 1, 2002 at 2:22 pm
Steve, thank you for quick response
I did all of that, but unfortunately 'Text File Group' wouldn't change from DEFAULT (until you will modify a default File Group back and forth as recommended 'solart')
August 1, 2002 at 4:14 pm
yes, you rebuild the index and you can specify the filegroup.
http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409
note the ON clause.
Steve Jones
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply