SQL Server 7.0 Upgrade Wizard and segments 
Author Message
 SQL Server 7.0 Upgrade Wizard and segments

We have a SQL Server 6.5 Database in which we have several segements (1
segment per devices). Whenever we try to upgrade this DB to version 7.0 the
upgrade wizard moves all tables into the default segment although we created
filegroups(with the same names as the segments) in the upgrade wizard.

Is there any way to upgrade the tables/indexes in a segment to a filegroup ?


Tue, 31 Jul 2001 03:00:00 GMT
 SQL Server 7.0 Upgrade Wizard and segments

You need to change the create table / index statements to place them on a
filegroup. You can do this by using the stop after each step option in the
Upgrade Wizard, after the 6.x scripting is done, you go change the create
table/index statements in the script files. After you are done you can
simply continue. There is no logical way to map segments to filegroups, that
is why they omitted that.


Tue, 31 Jul 2001 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. SQL Server Upgrade Wizard - SQL Server 7.0

2. SQL Server Upgrade Wizard 6.5 to 7.0

3. 4851 4852 while using upgrade wizard - sql server 7.0

4. SQL Server 7.0 Upgrade Wizard

5. problem upgrading more than 1 server with sql server 2000 upgrade wizard

6. SQL 7.0 Upgrade Wizard - resulting in suspected databases on SQL 6.5

7. 7.0 Upgrade Wizard doesn't like hyphens in server name

8. Upgrade-Wizard SQL 7.0

9. Upgrade Wizard SQL 7.0

10. SQL 7.0 upgrade wizard

11. SQL 7.0 Upgrade wizard question

Powered by phpBB® Forum Software