Segments -> filegroups during 6.5 -> 7 upgrade

Segments -> filegroups during 6.5 -> 7 upgrade

Post by Brian Proul » Fri, 11 Jun 1999 04:00:00

Is there any way, when upgrading a database from SQL Server 6.5 to 7.0, to
map 6.5 segments to 7 filegroups?

When the upgrade rebuilds the tables in the 7.0 database, I'd like it to
take all tables that were in segment X1 and build them in filegroup X1.
That's not a default behavior, which is reasonable, but I'm hoping there's a
way to do it.

Brian Proulx


Segments -> filegroups during 6.5 -> 7 upgrade

Post by Gert Draper » Sat, 12 Jun 1999 04:00:00

This is how I did this:

Run the Upgrade Wizard, if the option to stop after each step. After the
wizard generated the scripts on the 6.5 side, I changed the script for
creating the tables and add the on clause to indicate the filegroup. Before
that I create the database myself, and added the filegroups.

Now have the wizard continue, it will create the tables on the filegroup and
the data gets load on your filegroup.

You also have to do this for the indexes, I forgot that the first time :)

You can check after the objects are created if they are placed correctly,
using sp_help. Also be aware that clustered indexes are also on the same
filegroup and the table, open door, but just in case.


No live without an edge.