After upgrading SQL Server version 6.x databases to SQL Server 7.0 using the automatic configuration option, the resulting SQL Server 7.0 databases are smaller than their SQL Server 6.x counterparts. Does this mean that there was a problem with the upgrade?
If the Use the default configuration option is selected, the SQL Server Upgrade Wizard configures a new database size from the actual volume of data in the version 6.5 database automatically. To be sure that the SQL Server 6.x databases are upgraded correctly, compare the SQL Server 7.0 databases to their version 6.x counterparts, beginning with row counts and object names. To determine how much data is in the database, select the Edit Default Configuration option. For more information, see Upgrading from an Earlier Version of SQL Server.
Related Questions
- Why arent the configuration changes that were made using SQL Server Client Configuration in SQL Server 6.x reflected on the same computer in the SQL Server Client Network Utility with version 7.0?
- Does iWise allow automatic updating and recording of the version number of a configuration item, if the version number of any component configuration item is changed?
- How can I copy databases when upgrading to SQL Server 2005?
