开发者

Copy from SQL Server 2005 to SQL Server 2008 causes x2 data space #SQLHelp

开发者 https://www.devze.com 2023-01-09 11:40 出处：网络

A 开发者_StackOverflowcolleague of mine is copying data from SQL Server 2005 to SQL Server 2008. The destination database lives on a SQL Server 2008 instance but is set to Compatibility Level 90.The

相关专题：sql-server sql-server-2005 sql-server-2008

A 开发者_StackOverflowcolleague of mine is copying data from SQL Server 2005 to SQL Server 2008.

The destination database lives on a SQL Server 2008 instance but is set to Compatibility Level 90. The source database lives on a SQL Server 2005 instance and is set to Compatility Level 90. He is using SQL Server Integration Services 2008 to perform the copy.

The source table, data space used (MB) is 127,072. However, after the copy is performed the destination table, data space used (MB) is 252,942. Only data, i'm not including index data space.

The fill factor on the two databases may be different.

Thank you for your responses. Ultimately, the structure of the source and destination tables was different. Next time, I'll double-check my developer's work before accepting a statement at face value (ie: No the table structures are identical!)