Article ID: 300192 - View products that this article applies to.
This article was previously published under Q300192
BUG #: 354301 (SHILOH_BUGS)
BUG #: 101735 (SQLBUG_70)
If you use the Data Transformation Services (DTS) Import Wizard or the DTS Export Wizard to transfer objects from one database to another, the Filegroup settings for the object are not maintained even if the destination database does have the same filegroups.
Programs scripted using the TransferObjectsTask object from the DTS Package Object Library also fail to maintain the Filegroup settings for objects.
The wizards use the DTS Package Object Library to transfer objects between databases. The methods used are:
To work around this behavior, script out the objects on the source database and apply the scripts to the destination database. The Filegroup settings for the objects are now preserved. Use DTS to copy the data over from the source to the destination.
The Copy Database Wizard does maintain the Filegroup settings for all the objects in the database. However, using the Copy Database Wizard may not be convenient for the following reasons:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior